[drupal-devel] slow queries?
dan at civicactions.com
Sat Jun 25 19:11:12 UTC 2005
ahhh i re-read Allie's post and now see what he was saying (sorry).
This explains the behavior I describe below - in which this user *is*
initiating that query - as opposed to waiting for someone else's to execute.
> I'm not 100% sure - but in fact the max execution time is the time
> that a single http request will take to clear. I'm basing this on
> another php application that i have a lot of experience with. In that
> application there is an install utility. It will routinely time out
> during a particular data insert if the machine (DB) is slow. I
> believe one can see exactly this behavior with the CivicSpace install
> and the location tables (which are large). Put simply in both these
> cases on slow (DB) machines you will see a timeout at exactly 30
> seconds - upping the max execution time will improve this. However,
> as I said - I may be mistaken.
>> On Jun 25, 2005, at 11:40 AM, Gerhard Killesreiter wrote:
>>> I'd especially like to know why the maximum php executiomn time does
>>> not kick in.
>> I'm not special enough to follow your link. But, PHP's max execution
>> time is based on the time PHP takes to execute code itself. Waiting
>> around for DB queries or other operations aren't part of the equation.
>> Allie Micka
>> pajunas interactive, inc.
>> scalable web hosting and open source solutions
More information about the drupal-devel