On Fri, Mar 15, 2002 at 04:31:11PM -0800, Jonathan Leffler wrote:
> Dear Tim,
>
> I spotted the discussion about using these attributes to improve the
> performance of DBD::Oracle, and woke up since I don't remember them
> being discussed before.
>
> Running 'perldoc DBI' for DBI 1.21 gives:
>
The DBI doesn't manage the cache at all. The driver looks at
RowCacheSize when it does the prepare (and/or execute) and the does
whatever it needs to itself. Some databases, like Oracle8+ and Ingres
and probably others, provide a client-side row cache and so the
driver just has to pass on the RowC
Just as an FYI -- I was thinking about the same thing recently. That is:
Moving DBD::ODBC to use SQLExtendedFetch and allowing multiple rows to be
cached locally, hopefully in less network trips ;)
I'd like to work towards implementing the direct support in DBI (unless I'm
missing something) as