Re: my php script is very slow. help?

If you are using DB queries a lot, try to use LIMIT, this will save lot of your time. Tom Carter wrote:

Do you have many DB queries? What is the average size of the result returned? have you tried running timing functions on it to get a measure of how long the page is taking? theres many examples on the web.. You can also use these to calculate the time for different sections.. that should help you work out what is taking the time. HTH,Tom

Hi all I have Linux/PHP/MySQL. Some of my script really run very slowly. painfully slow. All data are fetched from the database. The tables in database are indexed. Still some scripts are very slow. I am using nested while and for loops. Any idea how to make them faster? What should I avoid in my scripting? thanks all ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net