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: [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]
