Re: Quickie Question
| From: | Jamie Alessio | Date: | Mon, 05 Feb 2001 20:31:45 +0000 |
| Subject: | Re: Quickie Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6405@lists.php.net to get a copy of this message | ||
First, check your indexes.. second, check your queries on your display list to
make sure you are only selecting data that is needed. I recently ran across a
problem where queries on a long list were taking forever to execute. I was
selecting * from the table thinking that I was using all the data - it turned
out I was using all the data except for a TEXT field. I removed that field from
the query the execution times went from 10+ seconds to a fraction of a second.
- Jamie