hi, 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`.`id`) FROM `tablename` WHERE (`tablename`.`city` LIKE '%Tampa%'); ~5sec w/o distinct ~ 6sec w/o distinct & w/o where ~4 sec 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.... thx -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMch1ucLvO1nQHgJteTxJ1G2_%3D16q7i-fOJcW9e76oN3GQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
