0.01 seconds is so fast that I wonder if that's actually because the query
cache is storing the query. Do you have query cache enabled?
James
At 6:35 am + 5/1/06, C.R.Vegelin wrote:
>Hi James,
>I have found similar - slowdown - effects for queries.
>However, it is not always clear what causes
t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 04, 2006 8:28 PM
Subject: SELECT DISTINCT uses index but is still slow
I have a query that takes a long time even though it is only examining the
index file. Is this normal? I would have thought that MySQL would be much
quicker to get
I have a query that takes a long time even though it is only examining the
index file. Is this normal? I would have thought that MySQL would be much
quicker to get the unique values from an index.
select distinct date_id from data_table;
# returns 89 rows in 23 seconds
- simple index on date_i
