… rows for each link and it does not solve all the problems – result counting and number of distinct sites were still pretty… for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day…. This also uses fair amount of tricks using fake full text search to retrieve all posts from given web site or forum from the…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
…. Searching for Audi A6 will give you a lot of Audi with different model numbers. Searching just for A6 gives no results at all… items to become visible in search results. I’m wondering if that is replication lag or issues with full text search index updates as I… some results (Though of course google takes other kinds of shortcuts) This however is frequently not the case with MySQL Full Text Search which…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… is you do not have to convert all tables at once. In some cases full text search is used on secondary small tables which… to have stale data in search results it can work pretty 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 to…
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… “All Results” while 500+ in names and all other groups, at the same time giving all pages accessible, so clicking to page #2 results in… to perform queries going beyond full text search. Such as finding the goods from the given group or Finding all Males looking for Females…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
….com – Search Engine which indexes tens of thousands of forums from all over the … Sphinx – Full Text Search Engine which we love to use where large scale search is needed….results were found matching this terms right from search results. It can show quite interesting data, for example searching…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… 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 …If you want to compare search to vecror based search you should use boolean match mode – this bypasses all word position check…
Post: Missing Data - rows used to generate result set
July 20, 2008 By 15 Comments
… BY GENDER even though full table scan is performed only rows with COUNTRY=’USA’ are used in results set which clearly puts… have clause like TITLE LIKE “%MYSQL%” you may instead use Full Text Search indexes. If you have WHERE ID%100=0 you can… so “use” all rows in result set while in reality only fraction of them will be needed for end result set as most…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… 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… GROUP BY in fixed memory which means results may be approximate – this is geared towards full text search applications when exact number is not… reports NULL group as a result. SphinxQL at this point is rather picky – it wants AS for all the expressions, it also…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
… why: – It does not do full sort but uses priority queue sorting to get top 1000 results. This is faster. MySQL simply…. This is quite typical. – Sort is performend in parallel. This search is performed on 4 nodes with 2 CPUs each. MySQL… they do not want full text search on the contrary they are asking about query to return all result set from full text search keyword matching standpoint and…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… used for full text search matching, but it is still extremely fast doing data crunching. I just tested right now performing search of “the… all 100.000.000 of matching document are traversed and priority queue sorting is performed to generate 1.000 best matching results… be an option to retrieve by filters only with no full text query. Sphinx should not be replacement for Database Server but…
