Displaying 2 results from an estimated 2 matches for "40secs".
2011 Feb 24
7
Fast in MySQL console, slow in ActiveRecord
...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 is not a web app. But
when I run exactly
the same query in a ruby script using ActiveRecord it takes about 45 mins -
far too long.
I am running all this on my work PC, 3 gig of memory. Windows PerfMon says
I have 2 gig available
and 1 gig on standyby. I am using rub...
2007 Feb 01
2
Indexing Performance Question (was tpop3d vs dovecot)
Since posting the previous thread we've setup a new system (Opteron
2.0ghz, 1gb ram, Fedora 6) for testing. I am hoping somebody very
familiar with the indexing portion of dovecot can shed some light on
this for me.
After much testing, I've come to one primary conclusion that dovecot
is possibly unnecessarily scanning or reading files within the
maildir directories. Take a mailbox