Mysql fulltext search speed

fulltext search speed

[hellboy]

HI All,

I'm just trying to complete my own fulltext search engine, everything seems to be ok. The final results are ordered by the relevancy etc. But what I struggle for is search speed. I have like 100.000 products in my DB, and it takes a while to get the results. Is there any let's say "tuning" for fulltext search to speed it up?

Also there is a question if the full text is necessary in the case I have only two Fields to perform fulltext search - but it has a significant impact on search relevancy though than just having search like:

"WHERE (LOWER(a.title) LIKE LOWER('%$text%')"

Can anyone advice help here please?

[eelixduppy]

You can refer to the documentation on optimization [dev.mysql.com] to see what you can do to make it run faster. If you want incredible speeds, SphinxSearch [sphinxsearch.com] is very good for full-text searches.

[hellboy]

Thank's a lot, heard about sphinx but not sure if it would be possible to install it on server where I'm only using webhosting service as a user not as administrator.?