Simple Machines Community Forum

General Community => Scripting Help => Topic started by: KirkhamsEbooks on July 12, 2017, 10:43:55 PM

Title: Search Script for SMF Database
Post by: KirkhamsEbooks on July 12, 2017, 10:43:55 PM
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
Title: Re: Search Script for SMF Database
Post by: Arantor on July 13, 2017, 02:37:33 AM
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.
Title: Re: Search Script for SMF Database
Post by: KirkhamsEbooks on July 14, 2017, 01:22:33 AM
Sorry the search results from my forum mysql would go into an rss feed with other search results.

Rick
Title: Re: Search Script for SMF Database
Post by: Arantor on July 14, 2017, 03:14:41 AM
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.