From: Francis Cianfrocca <garbagecat10@...>
Date: 2006-08-05T22:13:49+09:00
Subject: Re: [postgres] Is there a way to avoid having the library slurp-read the whole result-set?

On 8/5/06, Jon Egil Strand <jes@luretanker.no> wrote:
> >
> So, it seems to me that AR would not solve your problem. Maybe one could
> patch it with the sub-slurp posted in this thread.
>

I've found that AR exacts such a high price in performance that I
write applications using both AR and a native driver. I use AR for all
the lightweight stuff (for the productivity benefits), and code
against the native adapter for everything heavy, like the query that
is the subject of this thread. Even using AR's capabilities for
directly executing raw SQL code is measurably slower than using the
underlying adapters. You do lose portability across database engines
with this approach, but high performance in any database generally
requires a lot of engine-specific tunings anyway.