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
--
PHP Database 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]