Re: Question about concurrent request handling
Re: Question about concurrent request handling
- Subject: Re: Question about concurrent request handling
- From: "Ricardo J. Parada" <email@hidden>
- Date: Tue, 04 May 2010 19:43:57 -0400
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden