At 33 million records our search was getting too large for the old method we were using, and as a result our servers kept getting overloaded during the site's peak hours. We have now changed the standard phpbb fulltext we had to sphinx (http://sphinxsearch.com/), a search engine that is highly optimized for large databases. Not only does this improve performance and search speed (we went from search queries taking up to a second at peak times to 0.027 seconds) but it allows you to search for words with two or three letters, which was previously impossible.
If you encounter any errors please let us know. We are aware of the fact that some posts made during the search downtime will not be show up. They are being re-indexed as we speak.
EDIT: search engine is not indexing new posts after all, we are fixing it.
Use this for now:
https://www.google.com/cse?cx=007640456 ... #gsc.tab=0
If you encounter any errors please let us know. We are aware of the fact that some posts made during the search downtime will not be show up. They are being re-indexed as we speak.
EDIT: search engine is not indexing new posts after all, we are fixing it.
Use this for now:
https://www.google.com/cse?cx=007640456 ... #gsc.tab=0