StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWordpress search, large site, shared server-Should I use MySQL FullText Index, Lucene.net...?
text
Body
copied!<p>I'm creating a site that is running on a shared server and I need to find a good search engine. What search engine framework should I use to fit my requirements?</p> <p>Here are some requirements</p> <ul> <li>~100,000 documents need to be indexed</li> <li>Shared Server (but can run ASP.Net and php apps)</li> <li>Need to be able to restrict search results to specific tags, categories</li> <li>Need to be able to sort by relevance + popularity, or relevance + date</li> <li>A search is preformed on every page load (although i might implement caching). The way it works is kind of like stackoverflow. I have a main document and then suggestions for related documents are loaded on the right. This occurs on every page</li> <li>Software is free and has very little budget for any type of hosted search solution (at this time anyway)</li> </ul> <p>Here are my thoughts</p> <ul> <li>zend lucene search - performance is not good enough for such a large site</li> <li>Google custom search - number of sites/queries is limited</li> <li>Solr, Sphinx, java lucene - on a shared server so I cannot install these</li> <li>Lucene.net - I'm not sure if this is is possible. My hosting company allows me to run php and asp.net websites...but perhaps Lucene.net has to run as a separate process?</li> <li>MySql FullText search - I am not aware of performance for large sites like I have described</li> </ul> <p>This seems like a tough bill to satisfy but I'm hoping I don't need to come up with an alternative design.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload