On Thu, Nov 28, 2002 at 11:49:06AM +1100, Steve Baldwin wrote:
> Thanks for the reply. Is the timing a driver specific thing, or is this
> something that could go into the DBI POD ?
Driver specific.
> When you say "Use recent
> DBD::Oracle version" is that a general comment, or does the answer apply
> to a particular version. We're currently on 1.03 which I know is pretty
> old, but then we're also using Oracle 7.3, which is even older :-)
Some old versions had odd behaviour re row cache, needed to do something
like $sth->{NAME} between the prepare() and execute().
Read the changes since 1.03 here:
http://search.cpan.org/src/TIMB/DBD-Oracle-1.12/Changes
Tim.
> Cheers,
>
> Steve
>
> -----Original Message-----
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 28 November 2002 11:41 AM
> To: Steve Baldwin
> Cc: [EMAIL PROTECTED]
> Subject: Re: RowCacheSize - when to set ?
>
>
> Set before prepare. Use trace to see effect. Use recent DBD::Oracle
> version.
>
> Tim.
>
> On Thu, Nov 28, 2002 at 11:29:20AM +1100, Steve Baldwin wrote:
> > Can someone please tell me if the RowCacheSize needs to be set before
> > calling 'prepare' or before calling 'execute' if I want it to be
> > effective for a SELECT statement. I'm using Oracle, so I know it is
> > supported, but the RowsInCache statement handle attribute returns
> > undef, so it's difficult to work out when to set RowCacheSize. And
> > yes, I did read the fine manual but couldn't find an answer to this
> > question.
> >
> > Thanks,
> >
> > Steve
>
