variation on(Speed Up Code?)
| From: | George Pitcher | Date: | Tue, 26 Mar 2002 08:49:32 +0000 |
| Subject: | variation on(Speed Up Code?) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17911@lists.php.net to get a copy of this message | ||
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