…its inner workings well enough to answer questions about its internals from memory, such as “how does the insert buffer work?” or “how does MVCC work on…storage engines and appliances, etc. Technologies such as LVS, Nginx, Sphinx, and load balancers. Other operating systems such FreeBSD and …
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea… talking to Sphinx server. First of all, let us see how many records we have in this index and how long does it take to do a full scan: sphinx> select * from…
