Hi,
with a table with 33 rows, i have the row in 0s using index on term.
mysql select * from tx where term like 'Britney Spears' ;
+++
| id | term |
+++
| 327681 | Britney Spears |
+++
1 row in set (0.00
select * from terms where term like 'Britney Spears' limit 1;
This is taking anywhere from 35-55 seconds. There are only 350,000
records. Here are the indexes:
Keyname = PRIMARY; Type = PRIMARY; Field = id
Keyname = term; Type = UNIQUE; Field = term
Keyname = category; Type = INDEX;
Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 2:59 PM
To: mysql@lists.mysql.com
Subject: SLOW SLOW query - please help!
select * from terms
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
select_type = SIMPLE
table = terms
type = range
possible_keys = term, term_2 (I just created term_2, fulltext)
key = term (this means it's not using the one I just created?)
key_len = 255
ref