Tom Machinski wrote:
> On 10/28/07, ara.t.howard <ara.t.howard / gmail.com> wrote:
>> with modest resources.
> The problem is that for a perfectly normalized database, those queries
> are *heavy*.
> 
> We're using straight, direct SQL (no ActiveRecord calls) there, and
> several DBAs have already looked into our query strategy. Bottom line
> is that each query on the normalized database is non-trivial, and they
> can't reduce it to less than 0.2 secs / query.

Try enabling the MySQL query cache. For many applications even a few MB 
can work wonders.
-- 
Posted via http://www.ruby-forum.com/.