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
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
Even with concurrent request handling turned on, access to the
database is serialized.
Two backdoor ways of getting an additional EOF stack:
Most long queries (after optimization) I've had were related to
reporting. Moving the reporting to a separate application prevented
the long query
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
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?
Thanks,
Ricardo
___
Do not post admin reques
