Forum Search

5 Million Posts

[bobnew32]

See, there is a forum that has 5 million posts, and that needs a reliable search script. Any suggestions? ^^

[ergophobe]

Google
site:sitename.com search terms and "search phrases"

[rogerd]

Usually, the forum software's search script is best at decoding the content.

Atomz has a great search routine, but it will be quite costly for a site of that magnitude. You might try hotscripts.com or similar to look for third party search scripts.

[bobnew32]

This is supposed to be an in site search, so no google or atomz can be used. How does the phpbb search work, I think that like creates a search word index or somthing for each word with an id, then a different table that sends those words to each post that contains them. Seems pretty good, anyone have experience with this or other methods? Its extremely, extremely thankful due to its high priority. Thx

[bobnew32]

Well I decided to take that route, the only problem I have right now is putting the search string (the text they put into the input box on the form), and putting it into an array of somesort so I can do somesort of foreach or while command. I'm thinking that explode can somehow be used, but i'm not too sure how to access the array with a while loop so I can do some run commands for each word. Any help?

[XMLMania]

Have you tried the full text search function in MySQL [mysql.com]? If you keep the query string to a minimum then it should return results pretty fast. It also sorts results in relevance, and you can use boolean features.

hope this helps.