Search Script for SMF Database

[KirkhamsEbooks]

Has anyone written one they wish to share? I've done some php scripting now, but nothing with MYSQL yet. I want to add my forum results to a feed search script.

Rick

[Arantor]

Writing a search script and having a feed of search results are two different activities entirely and requires some serious thought to work if not going to be slow or take the server down under load.

More details about exactly what you want to achieve would be useful.

[KirkhamsEbooks]

Sorry the search results from my forum mysql would go into an rss feed with other search results.

Rick

[Arantor]

Yes, that's what I thought, the most efficient way to do this and not overload your server is to implement it the complete opposite way to what you think, so that you don't have to continually search the database because RSS readers hit feeds every 2-5 minutes even when nothing has changed, and hitting every 2-5 minutes on the heaviest part of SMF isn't good for your server.