Advertisement:

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

Offline KirkhamsEbooks

  • Jr. Member
  • **
  • Posts: 281
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: 69,313
    • StoryBB/StoryBB 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.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline KirkhamsEbooks

  • Jr. Member
  • **
  • Posts: 281
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: 69,313
    • StoryBB/StoryBB 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.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.