Re: String match is too slow in huge table
I have tried full text search but it has two issues:
1. It returns me results not relevants since it will search in both fields(i.e. it will return me fields in which the names are written as the surname and viceversa). I used something like 'having relevance > 10' but was still not enough. If you have more advices through full text search it might help.
2. It is still too slow. Althought we used the full text search it was still too slow against the same query running on Visual Foxpro on an identical machine. I refuse to the idea of Foxpro being faster than Mysql, so I'd been doing fine tunning without good results.
If anyone has any other advice I would really apreciate it.
Subject
Views
Written By
Posted
9260
December 23, 2004 11:37PM
3764
December 27, 2004 11:54PM
3414
December 28, 2004 12:38PM
3190
December 31, 2004 07:38PM
Re: String match is too slow in huge table
3384
January 03, 2005 02:54PM
2900
January 03, 2005 05:08PM
3141
January 04, 2005 06:57AM
2609
January 04, 2005 11:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.