… Full Text Search system you share it. Now speaking about index sizes – Sphinx always stores word positions which would take over half of the sphinx index. Plus MySQL stores timestamp and groupid for each document which is not needed for full text search itself, only…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… systems providing full text search systems. Unlike database management systems which normally should provide same result to same SQL query, for full text search systems results are often different, depending on relevance computing method. If you’ve been using sphinx in default search mode it…
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… booth (Andrew could not come so that was on me). Sphinx both turned out particularly interesting – unlike couple of years ago… magnitude speedups people often experience compared to MySQL build in full text search look too good to be true. I’ve clarified this… consideration which was built well exactly for the task while full text search in database systems if often afterthought. At the same time…
Post: Speaking on OSCON 2007
July 3, 2007 By 2 Comments
…. We’re also organizing Open Source Full Text Search BOF to hear from people working developing or using Full Text Search and related solutions. One of… people need from Full Text Search applications and which kind of problems they have with existing solutions, so we can make Sphinx Search better. Before…
Comment: Sphinx: Going Beyond full text search
July 24, 2007 By 18 Comments
[...] Sphinx: Going Beyond full text searchI ve already wrote a few times about various 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 1 billion of forum posts… [...]
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
… which present typical web LAMP application workloads Full Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL Searches.
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…, discussion can wait 
SPH_MATCH_ALL is not boolean search. This is search mode which uses phrase matching for relevance this is… it sorts by relevance for objects having the same date. Sphinx is not getting slower whatever sorting mode you’re using… problem is sorting – it is done by MySQL rather than full text search engine itself, which means it may be very slow. If…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… see that. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation…
Comment: Sphinx: Going Beyond full text search
July 24, 2007 By 18 Comments
… compare” – do you mean search relevance performance or something else ? Note Sphinx is also really an external full text search engine, there is simply a client which allows to use it as MySQL Storage Engine. We believe Sphinx is…
Post: Looking for someone with Chinese knowledge
January 11, 2007 By 25 Comments
… to implement CJK Support in Open Source Full Text search engine Sphinx . Initially we’re thinking to base search ob bi-gram indexing to keep… Japanese or Korean and would like us help us testing Sphinx support for these languages let us know. No special development…
