… we use sphinx based on attributes, but memory consumption is exaggerated, so we applied the technique described here, but the search results…
Comment: Sphinx search performance optimization: attribute-based filters
June 12, 2013 By 11 Comments
Post: Sphinx search performance optimization: attribute-based filters
January 15, 2013 By 11 Comments
… a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes… otherwise superb Sphinx performance. The Problem While Sphinx is great for full text search, you can certainly go beyond full text search, but before…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…: Q: If searching on multiple terms, can you get Sphinx to report which matched? The SHOW META command in Sphinx shows how many… would merge the delta index with the main index periodically. Sphinx Search also supports a supplementary in-memory RT index type that… found? No, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q: What…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
… using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against… SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day… other stuff is built with Sphinx. This also uses fair amount of tricks using fake full text search to retrieve all posts…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather… approximate – this is geared towards full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as… will likely stabilize soon. Sphinx also offers number of extensions to the SQL which are helpful for search use cases – WITHIN GROUP…
Post: Sphinx search performance optimization: multi-threaded search
January 16, 2013 By 10 Comments
Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue … what we are trying to achieve here. Sphinx has the ability to do distributed search out of the box – it was designed to scale out that way very early on. If your sphinx index…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
… actively support Sphinx as in our opinion it is great complement to MySQL when it comes to full text search tasks and… should be the best printed material about Sphinx out there, though as of now Sphinx has surely grown into the size to…. Anyways I’m excited of this new Sphinx milestone, and if you’re using Sphinx, be sure to try this new release…
Post: Sphinx Developer joins our team
January 8, 2007 By 7 Comments
… popular OpenSource full text search software Sphinx joins our team. Andrew will now have more time to dedicate to Sphinx development so cool…. Sphinx is great for high performance high quality or complex full text search applications – but If you’re looking at smaller search applications… of MySQL build in full text search. If there are some features which are missing in Sphinx or it is not best…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… Blog. Today we have published new search functionality for our site which is based on Sphinx. We have developed it as WordPress… Sphinx query language to search phrases or Search MyISAM in post title. Besides basic search functionality we’ve implemented list of last searches and Top searches…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… required is simple boolean full text search. Also FaceBook search does not seems to support phrases search, so searching for “Bill Smith” gets you… of course content search, ability for more intelligent searches, at least search for phrases. More interesting filtering would also be good – searching within certain…. We also already make sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as finding the…
