Brian, What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1; Running this statement will produce info on what index path is being used in the query. Also, can you use "=" instead of "like" in your query? Partha -- Partha Dutta, Senior 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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
