June 19, 2013

Post: FaceBook Search, Search for social networks

August 12, 2007 By 4 Comments

…With Sphinx which talks directly to the MySQL database we can get some 10…. full text search. Also FaceBook search does not seems to support phrases search, so searching for “Bill…best results. Say there were 5.000.000 matches and you fetched 10.000 of them – there well may be some of best matches…

Filed Under: Events and Announcements Tagged With: ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… by default, adding relevance sorting to the MySQL queries would make them even slower, I’… relevancy of search results between each engine?  If yes, which one seems the best? No, I…search expression.  But I don’t know a way to report exactly which rows matched, without doing additional searches…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Using Sphinx as MySQL data retrieval accelerator

October 30, 2006 By 25 Comments

…search matching, but it is still extremely fast doing data crunching. I just tested right now performing search of “the” which matched…matching document are traversed and priority queue sorting is performed to generate 1.000 best matching… which may be slower than MySQL. MySQL Make it so one would …

Filed Under: Insight for Developers Tagged With: ,

Post: Should MySQL Extend GROUP BY Syntax ?

August 17, 2007 By 11 Comments

… limitations in SQL language which is not offset by any MySQL specific extensions,yet As you can see if you want… – we wanted to group search results by thread and return only one best matching post from each thread while matches themselve could be sorted… Web applications do not care – they are stuck enough in MySQL they would have rewrite a lot going to other database…

Filed Under: Insight for Developers Tagged With: ,

Post: Power of MySQL Storage Engines

March 5, 2007 By 3 Comments

… PBXT . Plus there is Falcon storage engine being developed inside MySQL. All of these storage engines are however similar in their… figure out which storage engine or storage engine mix is best match for you. Believe me people even often have hard time… to read sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures I…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

…. Attributes on the other hand are sort of like unindexed MySQL columns. They are the extra details you may want to… attribute for all the records that matched the full text search query. For few hundred thousand of matched records, checking attributes is not… it is definitely not the best use case for Sphinx. When you have full text search keywords that match many documents (and therefore…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… our search term, then that term *must* appear in the search results. But does it? With 5.5: mysql: SELECT id, full_name, MATCH… quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name, MATCH(full_name, details) AGAINST… important best practice even if FTS isn’t involved. Always test how your application behaves as a result of a major MySQL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

July 20, 2008 By 2 Comments

… choice awards finalist in 3 nominations (Best Project, Best Project for Enterprise, Most Likely … is about “EXTENDED2″ matching mode – which is faster and more feature full search mode than the …MySQL build in full text search uses) you can get performance another 20-100% better though search…

Filed Under: Insight for Developers Tagged With:

Comment: Using Sphinx as MySQL data retrieval accelerator

November 7, 2006 By 25 Comments

…matches keyword with such poor selectivity (over 50% matching rows) simple full table scan with limit actually would offer best… with MySQL Cluster sort would be done on MySQL server – …search on the contrary they are asking about query to return all result set from full text search keyword matching…

Filed Under: Insight for Developers Tagged With: ,

Page: Consulting for MySQL

July 31, 2006 By

…Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search…

Filed Under:
« Older Posts