When it comes to searching this forum, for threads about search scripts, the answers confuses me a lot.
I have read about mysql fulltext searches,
PHP solutions where you filter out noisewords from the keywords etc.
But? Everybody seems to have their favorites, and I have to find out what I will need, in order to make the best solution for my website.
Therefore:
1: The MySql fulltext search. Is it fast enough for small to medium sized websites?
2: Does it work with other languages than english (indexing)?
Is there any idea in doing this, and is it possible:
I would like to make two tables. One for the text and one for the related keywords, like this.
Keywords: keyword_id , words
Text: id, title, text, keyword_id
Every keyword has got its own row.
The column keyword_id in text table holds an id for each keyword related to the text.
So when queried, the search looks to the keywords table and finds the querywords and their id and then searches the text table for matching keyword_id.
Don't quite know how to code that query???
And by the way, how big does a database have to be, to make some kind of fulltext searches too slow?
Out of my mind or what? 😕 😉
