RE: slow query when searching database of over 2 million records

2004-06-28 Thread Amit_Wadhwa
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

Re: slow query when searching database of over 2 million records

2004-06-28 Thread SGreen
Fax to: 06/28/2004 07:15 Subject: slow query when searching database of over 2 million records AM Please resp

RE: slow query when searching database of over 2 million records

2004-06-28 Thread Victor Pendleton
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

slow query when searching database of over 2 million records

2004-06-28 Thread Aasef Iqbal
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