List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 29 1999 4:46pm
Subject:Re: Slow Query
View as plain text  
At 12:14 PM -0400 10/29/99, PinkeshP@stripped wrote:
>following query takes 28.52 seconds!!!
>
>mysql> select count(*) from reminder where custid="abcd10asdf5";
>+----------+
>| count(*) |
>+----------+
>|     5553 |
>+----------+
>1 row in set (28.52 sec)
>
>I have total of 109229 records in table. custid column is indexed. 
>Anyone help me to make this query run faster?

Indexed how?  As the first column of an index, or as the 2nd (3rd, 
etc.) column of
a multiple-column index?

-- 
Paul DuBois, paul@stripped
Thread
Slow QueryPinkeshP29 Oct
  • Re: Slow Querysinisa29 Oct
  • Re: Slow QueryPaul DuBois29 Oct
  • Re: Slow QuerySteve Ruby29 Oct