Hi,
I find in our database, select "% string %" is very slow (>1
minute). The database size have only 2M rows, any idea how could I get
faster response? Thanks a lot.
CREATE TABLE Books (
isbn char(10) NOT NULL default '',
Title char(255) NOT NULL default '',
KEY isbn (isbn),
KEY Title (Title)
}
select count(*) from Books -> 2028971
select count(*) from Books where Title like "% cisco %";
+----------+
| count(*) |
+----------+
| 86 |
+----------+
1 row in set (1 min 25.09 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php