[drupal-devel] slow queries?

Dan Robinson 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.
>
> Dan
>
>
>>
>> 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.
>> http://www.pajunas.com/
>>
>> scalable web hosting and open source solutions
>>
>>
>



More information about the drupal-devel mailing list