Have you ran an explain plan on the query to identify the execution path?
-Original Message-
From: Aasef Iqbal
To: [EMAIL PROTECTED]
Sent: 6/28/04 6:15 AM
Subject: slow query when searching database of over 2 million records
Hi,
I am working on a web project project where one of my
You should only need to do your second query and use the
SQL_CALC_FOUND_ROWS and a new query using SELECT FOUND_ROWS()to minimize
the number of times you need to _actually_ search your database.
see: http://dev.mysql.com/doc/mysql/en/SELECT.html
and:
Use MySQL Query Caching
-Original Message-
From: Aasef Iqbal [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 4:46 PM
To: [EMAIL PROTECTED]
Subject: slow query when searching database of over 2 million records
Hi,
I am working on a web project project where one of my pages has to