Whats the best way to do a search?

I've got a database with a lot of articles and I want to add a search function to the website. What would be the best way to achieve this? The database size is still fairly small but will increase.

[Join us @ facebook]

Well that depends.

The fastest way for the database, is by having some small VARCHAR fields in your table that indicate keywords.

Those fields should be indexes. But this way will not have the best results.

The best it would be if you would use the article's title or/and text, but this would create a huge overload on the server (that also depends of traffic of course), but you could do this better by creating some kind of cached results for the queries.

Hope my post helps

[Guest]

[37.937]

Yahoo crawler, Googlebot, Baidu Spider, Msnbot, Gigabot