Hello all! I am glad i found this site and i have to say it is awesome! Helped me in a lot of ways using mysql. Here is my problem. I have two tables in which i store and index keywords for search engine purpose. Tables are: keyword2 (230.000 rows) CREATE TABLE keyword2 ( id int(10) unsigned N…

Count .... Group By... any other way?

Peter October 12, 2006, 4:04pm 8

Good to hear you got your problem solved

On medium data sizes both sphinx and MySQL FT Search work well, sphinx however scales much better

Topic		Replies	Views
MySQL Query Optimization - Trouble with Indices Other MySQL® Questions	2	508	November 3, 2009
Cannot get MySQL to use indexes for query Other MySQL® Questions	2	408	January 24, 2013
Help with really big tables Other MySQL® Questions	1	377	July 4, 2007
Query Optimization - Indexes Other MySQL® Questions	5	535	October 18, 2009
Need help for optimizing query Other MySQL® Questions	0	352	August 5, 2008