"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; Field = category, ASIN, already_seeded, id, term
`term` is a varchar(255). What's wrong?? Any thoughts appreciated. Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
