On 27-Sep-08, at 7:54 PM, William Hatch wrote:
We've looked extensively at the db logs; no slow queries are being triggered, in fact, the total queries per second drops to almost nothing when the app is running slowly.
Did you also check the query logging in the application?
I haven't tried closing and reopening, other than bringing the app up and down, of course. Do you think that would provide some benefit? I suppose I could do it on each batch iteration.
It won't bring you any benefit if everything goes right there, but it might point out a direction where to look.
Also memory could be a problem. The Garbage Collector could be overwhelmed if you create and dispose a lot of objects (maybe even more unnecessary objects for temporary things or so).
Shark or JProfiler might give clues here. cug -- Real World WebObjects Bootcamp at the Big Nerd Ranch: http://www.bignerdranch.com/classes/real-world_webobjects.shtml _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
