Displaying 1 result from an estimated 1 matches for "ruby_runtime".
2011 Feb 24
7
Fast in MySQL console, slow in ActiveRecord
Has anyone experienced an ActiveRecord query being much much slower than
running the equivalent
query in the MySql console?
I am running a simple "group by" query with one condition on a table with 7
million records. When
I run EXPLAIN it says that it will have to scan over all the records - well
that''s OK. In the MySQL
query it takes 1min 40secs which is OK for me - this