Page 2 of 2
Re: All queries very fast, except one
Posted: Thu Oct 25, 2012 11:30 pm
by pschmehl
Thanks. That is most helpful.
Re: All queries very fast, except one
Posted: Sat Oct 27, 2012 2:52 pm
by Weirdan
You may want to enable
output buffering in php.ini if it's not enabled already. Without buffering, php has to wait for client to acknowledge data it receives as PHP generates the output. Basically, every echo "something" sends "something" to the browser and waits for confirmation.
Be warned that it may cause memory usage to jump up, in which case you will probably want not to just set it to 'On' but tweak the value using specific buffer size. Something like 128KB, or even 1MB should probably suffice.