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
Fax to:
06/28/2004 07:15 Subject: slow query when searching
database of over 2 million records
AM
Please resp
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
Hi,
I am working on a web project project where one of my pages has to show a count of
total number of matches found and short text for few of them, just like a
search engine.
I need to issue two queries first one fetches a count for total matches found and
second query finds detail to 10/20