… projects using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over… traditional for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… well. Use Sphinx or other external full text search engine This is what we use a lot especially if performance of full text search is an issue… it often takes just couple of hours to get the full text search running Sphinx instead of build in full text search.
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will give… not the case with MySQL Full Text Search which both will skip to frequent keywords in natural language search and because it is using… at alternative solution, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… know build in full text search is currently limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to use full text search solution for all storage…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… on crawler in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application… LAMP is and S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point… found matching this terms right from search results. It can show quite interesting data, for example searching Britney Divorce will show huge…
Post: Sphinx Technologies launches Sphinx Support
March 24, 2009 By 1 Comment
… ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in… Sphinx Technologies is based on traditional support model with limit (or no limits) on number of incidents submitted. If you have Full…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… simple full text search features are required. As ordering is not done by relevance what is required is simple boolean full text search. Also FaceBook search does… usages. We also already make sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as finding the goods…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
… we actively support Sphinx as in our opinion it is great complement to MySQL when it comes to full text search tasks and other… to what MySQL build in full text search uses) you can get performance another 20-100% better though search result quality will be reduced. Or if you’re not interested in full-text ranking altogether, for example…
Post: Sphinx Developer joins our team
January 8, 2007 By 7 Comments
… of popular OpenSource full text search software Sphinx joins our team. Andrew will now have more time to dedicate to Sphinx development so cool new… not. Sphinx is great for high performance high quality or complex full text search applications – but If you’re looking at smaller search applications we…
