Do some profiling. Use PEAR's Timer class or just add here and there some echo
microtime(). Find where is spent most of the time. If
it is in the queries than look at your db and find out whether you missed to add some
index. If indexes are ok, try to make joined
queries (for mysql - LEFT JOIN (RIGHT JOIN) is probably the best choice escpecially if
you have very big tables).
Regards,
Andrey Hristov
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 10:49 AM
Subject: [PHP-DB] variation on(Speed Up Code?)
Hi all,
One of the pages in my site takes up to 10 seconds to display (depending on
number of records (30 records takes 10 secs).
The cause of the problem is the amount of information I am displaying for
each record. I do multiple queries for each record to find out different
things such as its position in the workflow, its price, etc. None of these
are stored in the db, but are calculated on the fly depending on the data
held.
Apart from storing the result in the db can anyone point me in the direction
of some efficient handling routines?
Code is available if anyone wants bloat-mail!
MTIA
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
