Looking to add search to my site

php, mySql

[scratch]

Will search mySQL database, hopefully will have boolean capabilities, as well as a way to rank results, and be able to deal efficiently with a lot of traffic.

Starting data will be 12,000 items and might grow to 50,000 worst case.

Would prefer simpler system that i can integrate with my existing site and customize as needed.

Are there any recommendations.

[mack]

FDSE? no mysql but possible :)

[Paul in South Africa]

Have a look at this article [devarticles.com]. It helped me a lot.

[lorax]

Give DGS Search a try. I've used it on several websites and it works like a champ.

[Nick_W]

mnoGoSearch.org

Very impressive.

Nick

[brotherhood of LAN]

Looking to make it from scratch? :)

FDSE? no mysql but possible

FDSE can use mysql, though I think its more of a "add-on", I think it works faster in its original text file format.

[scratch]

I think i am going to wind up doing it from scratch...

Why does every developer have register globals on--it is not that hard to program with the default config of php in mind.

Thanks paul for that link, i am also using what i can from DGS and something called sitesearch.

Most of the solutions above seem to be modified to use mySQL but are meant for their own proprietary data formats. Isn't this what mySQL is for.

What is the best way to paginate thousands of results. From what i see you do the search, take the first ten, then do the search again and pull 11-20 inside your query. Is there a better logic to attack this while still using mySQL or is that 'generally accepted'. I'd imagine that every page load redoing the same query could really tax the processor.