Advertisement:

Author Topic: Search Script for SMF Database  (Read 350 times)

Offline KirkhamsEbooks

  • Jr. Member
  • **
  • Posts: 276
Search Script for SMF Database
« 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

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 67,346
    • Arantor on GitHub
Re: Search Script for SMF Database
« Reply #1 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.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline KirkhamsEbooks

  • Jr. Member
  • **
  • Posts: 276
Re: Search Script for SMF Database
« Reply #2 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

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 67,346
    • Arantor on GitHub
Re: Search Script for SMF Database
« Reply #3 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.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.