i am using ransack and i am experiencing slow queries, eg on the search sites i have a query like that:
SELECT DISTINCT COUNT(DISTINCT
tablename WHERE (
city LIKE ‘%Tampa%’);
w/o distinct & w/o where
what do you guys do? i reviewed all indexes, datatypes, memory is ok. no overload.
and yet i am feeling that i am missing something…