On Sunday 11 June 2006 12:25 am, Octavian Rasnita wrote:
> Hi,
>
> I have the following table:
>
> CREATE TABLE `z` (
> `hash` varchar(16) NOT NULL default '',
> `title` varchar(255) NOT NULL default '',
> `body` text NOT NULL,
> FULLTEXT KEY `title` (`title`,`body`)
> ) ENGINE=MyISAM DEFAU
hat
rank.
I have set MySQL to also index the 3 chars words.
The problem is that this query takes more than 12 seconds, and for some
other one-word searches it takes almost 30 seconds, and this is very
much for a table with only less than 200.000 records.
Can I do something to increase the searc
