Mysql fulltext against keywords indexing

What’s the best way to construct a search engine in Mysql over more than 40 000 news articles? Using the build-in fulltext indexing (and match against) or building a keywords data base to search in before?

Hi,
Full text indexing would be quicker, but it really depends on how you create the search script. A keywords database would be good for a simple search engine, but will take longer to construct, and for 40,000 records, it could take a while!

It really depends on your needs: time or speed. I would personally setup indexing for a larger, more complicated site, and save keyword based querying for simpler sites.

i agree with mytch go for the full text indexing, it will be less hassle to set up.

Ok thanks to all.

Did you reed “Slapping together a search engine for your database is easy with PHP and MySQL” article on URL It confused me… At the end I don’t know what’s the best method.

If the fulltext method is quicker, why so few information about it? I found a nice article on URL but that's the only one… is there more info (not official Mysql) on the net? Is that method proven?

Thanks again!

Karim,

karimbolivia, we actually have a article here on devarticles about setting up a basic search engine

Developing A Site Search Engine With PHP And MySQL

that should help you out heaps