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
If your Database is big, avoid loops which goes to whole the DB.
This is just one thought.
DT
- Original Message -
From: hassan xaaji [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 15:36
Subject: [PHP] my php script is very slow. help?
Hi all
I have Linux
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
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
] my php script is very slow. help?
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
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
6 matches
Mail list logo
