Hey all i am running mysql 4.1.20.
I have a table with about 2.5 million records and i have to do queries
on it that looks something like:
select * from table where field1 like '%some%thing%' order by field2
This is ofcourse very slow since it refuses to use indexes...
i have fairly large read_rnd_buffer (32M) and sort_buffer (32M) but this
query is still slow as hell...
Any hints as to how i can optimize the query? or tune my server settings
to produce faster results?
Regards
Martin Jespersen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]