On May 4, 2010, at 6:23 PM, Chuck Hill wrote: > On May 4, 2010, at 3:17 PM, Ricardo J. Parada wrote: >> >> If I have concurrent request handling enabled and I have a query taking a >> long time, will other requests block when they try to access the database >> until the request that issued the long query finishes? > > > They will block if they attempt to access the database. > > To avoid this, you need to create multiple EOF stacks. Then, only the > requests using the same stack will block. :-) A better plan, if possible, > is to move this query to it's own EOF stack. Usually that is done along with > a long response page. Or try to optimize the query if that is possible.
Thanks Chuck. More questions related to this. 1. If the the processing of a request involves multiple queries, could another request executing concurrently be able to proceed in between the two queries and access the database for example? 2. I'm using Wonder... Would you say that ERXObjectStoreCoordinatorPool is what I need to easily accomplish the multiple EOF stacks within an application instance? Thanks a million Ricardo _______________________________________________ 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]
