Faster Phrase Queries with Bigram Indexing

Bigram indexing lets you dramatically increase the performance of phrase queries. This post will tell you how it's done. The Idea Assume that some of your phrase queries are occasionally very slow. The root cause is usually simple: that, most likely, is just because they're processing way too much data.

Sphinx 2.0.8-release is Available

We're happy to announce that Sphinx 2.0.8, the generally recommended release, is now available. In case you are wondering, to us, "generally recommended release" means that all features are stable and complete. We know that some of you are already making use of the shiny new features included in the beta release, but we would like to tell the rest of you about Sphinx 2.0.8.

Sphinx @ Tradebit: Fully Dynamic On-Site Search

By Ralf Schwoebel, CEO of Tradebit, Inc., April 2013 With data on the web growing so fast, the topic ?SEARCH? is as hot as it can get. Searching for products, related articles or tracking the user beh

Sphinx @ Percona Live: Update

The Percona Live: MySQL User Conference is just around the corner! Before we begin our trek to San Jose, we want to provide you with one last announcement about our upcoming activities. First of all, as we've previously mentioned, Andrew Aksyonoff (Sphinx's founder) is going to be delivering a Sphinx tutorial on the 22nd of April at 1:30pm - 4:30pm in Ballroom H.

New BM25 functions and IDF operators in custom rankers

Until 2.1.1-beta the functions exposed in custom rankers for handling relevancy based on term frequency and Inverse Document Frequency (IDF) did not take field or document lengths into account. In 2.1.1-beta, Sphinx includes functions that take relevance ranking to the next level.

Highlighting some changes in Sphinx 2.0.7

Can't wait to dig into Sphinx 2.0.7? Here's a sneak peek at some of our activities: Issue #1382: A diligent and devoted Sphinx user informed us that trying the search "@name }" returned syntax error in results.

RealTime Index Improvements in 2.1.1

We are proud to announce that the Sphinx 2.1.x tree has been finalized. Sphinx 2.1.1-beta will be released in the very near future! We were so excited about the work we've accomplished that we couldn't wait to start sharing some of the new features that will be included in 2.1 series.

SphinxQL 2.1.1 Cheat Sheet

The EXIST() function Previously, searching in non-existing fulltext fields was possible using @@relaxed operator, but attributes didn't have anything similar until now. The EXIST() function is an equivalent of @@relaxed, but it is specifically to be used for attributes: SELECT *, EXIST('gid', 6) as cnd FROM i1, i2 WHERE cnd>5 This example will return results only from the index that doesn't have the "gid" attribute.

A new tool in the trunk: wordbreaker

In 2.1.1, Sphinx's main application brings not only new features, but also a handy new tool: wordbreaker. As its name suggests, wordbreaker splits long words into several smaller words. This tool has many applications, but in this post we'll focus on breaking apart URLs.

Sphinx 2.1: JSON Attributes

We're delighted to announce that Sphinx 2.1 begins support of JSON attributes. While complete support is yet to come (some quirks and limitations are yet to be ironed out), we consider this to be a major step ahead. Storing sparse key-value data is no longer a fundamental issue in Sphinx!

Comparing Compilers

We all want to see Sphinx run as fast as possible. How do different compilers impact Sphinx's performance? We imagine that many of you are using the default compilers available on your machines. Is this wise? With some simple testing we confirmed that certain compilers are friendlier to Sphinx's performance than others.

Sphinx @ Percona Live: MySQL User Conference

It's that time of year again. The annual migration of MySQL users will soon begin! In a little more than one month's time, much of the MySQL ecosystem will be gathered at the Percona Live: MySQL User Conference and, as usual, you can expect an appearance from the Sphinx Team.

Sphinx 2.1.1-beta, Available Now!

We've been talking all about it, now it's here! Download Sphinx 2.1.1-beta to see what lightning fast search is all about. Summary Better real time indexes, they're catching up with on disk indexes! Built in options for high availability Fulltext search and ranking optimizations JSON attributes Wordbreaker New SphinxQL commands and options RT Indexes Realtime indexes were lacking some of the functionality of on-disk indexes.

Sphinx @ Percona Live: MySQL User Conference " full-text diary | Sphinx | Open Source Search Server

It's that time of year again. The annual migration of MySQL users will soon begin! In a little more than one month's time, much of the MySQL ecosystem will be gathered at Percona Live: MySQL User Conference and, as usual, you can expect an appearance from the Sphinx Team.

Sphinx 2.1.1-beta, Available Now! " full-text diary | Sphinx | Open Source Search Server

We've been talking all about it, now it's here! Download Sphinx 2.1.1-beta to see what lightning fast search is all about. Summary Better real time indexes, they're catching up with on disk indexes! Built in options for high availability Fulltext search and ranking optimizations JSON attributes Wordbreaker New SphinxQL commands and options RT Indexes Realtime indexes were lacking some of the functionality of on-disk indexes.