Be careful with any sort of nested loops. You may not be able to avoid
them, but if you nest a while loop within another while loop, and simply
iterate through results, you will have quadratic running time. This
isn't a big deal if you've got 20 results, but for every increase in N
(size of result) your running time will increase N^2. So, if you've got
a large dataset, the process time will be enormous.
Jack
-----Original Message-----
From: hassan xaaji [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 5:51 AM
To: [EMAIL PROTECTED]
Subject: [PHP] my php script is very slow. help?
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
