full text search (no replies)

This Comment will be submitted for moderation and will not be accessible to other users until it has been approved.
Submitted by programmer on Thu, 08/14/2008 - 12:38.
::

I have a table with 40 milions rows and the fulltext index for the column 'name' takes longer than 2 minutes for any search.

An example of the select is "select nome, nascimento from table clientes where match(nome) against('ricardo')>0.01 and match(nome) against('medeiros')>0.01 limit 100"

Details: the min_word_len is 2 and I has repaired the table after restart de server.

How can I get better results?

thanks

Post Comment

  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.