free open-source SQL full-text search engine

Need a hand? +1-888-333-1345

Sphinx Home Blog About Downloads Mailing list News archive Community Documentation FAQ Articles Presentations Contributed software Forum Bug tracker Wiki Services Support Consulting Licensing Contact us Misc Powered by Sphinx User stories Buttons  Subscribe in a reader

News entry Oct 14, 2007. 0.9.8 dev news: several new features, and many bugfixes This time, a couple of weeks following Highload was mostly dedicated to bugfixing. Most prominently, SphinxSE should now compile and work fine with most MySQL versions (and I personally tested quite a few). However it seems we simply can not stop adding new features. So this update also includes: full scan support; per-field prefix/infix indexing support; an option to enable/disable star syntax on per-index basis; an option to specify per-index weights and sum weights for matches coming from different indexes (instead of simply using the match from last specified index). Full scan, or in other words the long awaited “empty query” feature, means that Sphinx will now process and return all document IDs if there's no query string specified. This is useful in case you do not want to perform any full text search, but rather Sphinx-side filtering or grouping only (which in some specific cases turns out to be more efficient that MySQL-side). The interesting thing to know about full scan is that there is a simple internal optimization which could throw away blocks of records early. It works best when long ranges of documents (sorted by ID) only have a few different attribute values. So if you're filtering on timestamps which grow along with document IDs, this is going to be especially fast with full scan. As usual, the new snapshot is available from Downloads section. Permalink // del.icio.us // digg // stumble Add comment Name and Comment are required; other fields are optional. Email will never be displayed nor transferred nor used for anything else except getting back in touch. Register and then login to skip spambot check and filling your name every time. Sorry, no markup at all for now. Name (*) Email Website Comment (*) 7 * 8 = ?