Re: Question about concurrent request handling
Re: Question about concurrent request handling
- Subject: Re: Question about concurrent request handling
- From: Chuck Hill <email@hidden>
- Date: Tue, 4 May 2010 16:50:27 -0700
On May 4, 2010, at 4:43 PM, Ricardo J. Parada wrote:
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?
Yes, it is possible. It depends on where the queries originate from.
If the OSC gets unlocked between them, another request can get in. If
it is a long save process, then the OSC will stay locked for the
entire duration of SQL being sent to the database.
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?
Yes, I think that is it. I also think that you can just set some
properties to get this used.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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