Hi,
I invoke an agent through LEI activities. It takes 300000 records from DB2 v7.1 and populates those records in Lotus Notes Database. When i invoke that agent through LEI activity, it takes 16hrs to get it done. If i run the same agent from my workstation, it takes only 6 hrs. Can anyone advise me how to bring down the gap ?.
Regards,
Karthik KS
Inida.
Subject: Agent Takes 16hrs to process 300000 documents
There are severala new article on application performance that appear in this month’s articles, perhaps you will find them helpful. A lot depends on your application design, and the first article gives you some tips on what to look at and comparison of some things that work faster than others:
Subject: RE: Agent Takes 16hrs to process 300000 documents
I suspect the task is being given a higher priority by your computer when you run it in the foreground, versus the resources the server chooses to devote to it since the server has to be doing lots of other things at the same time. Also, perhaps you have a faster processor or a faster network connection to the DB2 database.
I don’t know what kind of processing you’re doing, but even 6 hours seems like a lot for 300,000 documents. That comes to just about 14 documents per second. Perhaps you could streamline your code using some of the performance tips from the LC LSX chapter of this book: http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246067.html?Open