Sometime it is needed to handle a lot of rows on client side. Usual way is send query via mysql_query and than handle the result in loop mysql_fetch_array (here I use PHP functions but they are common or similar for all APIs, including C). Consider table: CREATE TABLE `longf` ( `f1` int(11) NOT NULL auto_increment, [...]
Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
As we 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 engines. This version also adds a lot of other [...]
