[Rails] help with ransack / mysql performance

Ruby on Rails Thursday, October 12, 2017

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+unsubscribe@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.

Ruby on Rails