Re: mysql search performance

[Rick James]

While you have only 3000 rows, rearrange your table by moving the bulky (I assume) text fields to a parallel table. This will help in searching.

It would be nice to see the SELECT and the other table definitions.

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]