News for hackers. Stuff that matters.
Re:Web search 30M rows sub-second, cheaply by nreece on Sunday November 22, 2015 @05:25PM (#10611755)
I prefer, and suggest, Sphinx over Elasticsearch. It has better performance, easier ETL and handles large datasets better.
Re:Web search 30M rows sub-second, cheaply by boyter on Sunday November 22, 2015 @05:28PM (#10611769)
Agreed. Elastic search is fantastic, but for simple search that needs to be fast Sphinx is hard to beat. I have been using it for years on searchcode.com and have never hit an issue with it that was not due to my own mistakes.

A fantastic piece of software.

Re:Web search 30M rows sub-second, cheaply by STRML on Sunday November 22, 2015 @06:39PM (#10612016)
Wow. What a great plug. Loving searchcode.com. Thank you for running such a great service! I have endless frustration trying to search Google or DDG for these things.
Re:Web search 30M rows sub-second, cheaply by boyter on Monday November 23, 2015 @04:45PM (#10617542)
Thank you!
Re:Web search 30M rows sub-second, cheaply by jgord on Sunday November 22, 2015 @06:00PM (#10611888)
I had a look at the obvious things, by no means exhaustive - but I hadn't heard of Sphinx, thanks for the suggestion.