Re: fulltext search performance

2001-01-24 Thread Sergei Golubchik
Hi! On Jan 23, Alex Krohn wrote: > Hi, > > Has anyone used the fulltext indexes in 3.23 and can share their > experiences? I've only done limited testing, but was quite disapointed > with performance. > > We have an import of DMoz data into a table with Title, URL and > Description fields as a

RE: fulltext search performance

2001-01-23 Thread Paul Rydell
I have spent quite some time trying to tune up fulltext indexing (coincidentally I am also working with the DMOZ data in my database). I too noticed how slow it goes when you order by relevancy... but there is no reason to order by the relevancy because it returns the results in descending order