Hi all.
I'm have DBD::Oracle 1.07 on production server and just wondering that
call of selectall_arrayref causes call of fetch for each row.
On newest version of DBD::Oracle selectall_arrayref works without
calling fetch sub for each row in result set.
Is there any way to speed things up on this old DBD::Oracle ?
--
WBR, Eugene Krivdyuk
On 2006/10/31 Tue 06:59:18 , John Scoles wrote:
> I doupt it. It is possiable but you would need to do alot of programming.
> With DBD 1.07 you are talking a version of the program in mid 2001 so it
> was designed for most likley OCI 7 or an early OCI 8
> what type of Oracle client do you use and what verstion of Perl?
Perl: 5.6
Oracle: 9i
>
> You might be better off upgrading to the instant client, Perl and DBD and
> see if you can still connect.
I can't upgrade DBD::Oracle on this machine as I have no (and will never
have) root access to production server.
--
WBR, Eugene Krivdyuk
You are out of luck then!.
If you can't get root access you will not be able to make any changes to DBD
Oracle as you would have to compile and install the new version.
Cheers
----- Original Message -----
From: "Eugene Krivdyuk"
To:
Cc: "Sergey Brutsky"
Sent: Tuesday, October 31, 2006 7:41 AM
Subject: Re: DBD::Oracle 1.07 and selectall_arrayref
> On 2006/10/31 Tue 06:59:18 , John Scoles wrote:
>> I doupt it. It is possiable but you would need to do alot of
>> programming.
>> With DBD 1.07 you are talking a version of the program in mid 2001 so it
>> was designed for most likley OCI 7 or an early OCI 8
>> what type of Oracle client do you use and what verstion of Perl?
>
> Perl: 5.6
> Oracle: 9i
>
>>
>> You might be better off upgrading to the instant client, Perl and DBD and
>> see if you can still connect.
>
> I can't upgrade DBD::Oracle on this machine as I have no (and will never
> have) root access to production server.
>
>
> --
> WBR, Eugene Krivdyuk
>
>
On Tue, Oct 31, 2006 at 02:41:11PM +0200, Eugene Krivdyuk wrote:
> On 2006/10/31 Tue 06:59:18 , John Scoles wrote:
> > I doupt it. It is possiable but you would need to do alot of programming.
> > With DBD 1.07 you are talking a version of the program in mid 2001 so it
> > was designed for most likley OCI 7 or an early OCI 8
> > what type of Oracle client do you use and what verstion of Perl?
>
> Perl: 5.6
> Oracle: 9i
>
> > You might be better off upgrading to the instant client, Perl and DBD and
> > see if you can still connect.
>
> I can't upgrade DBD::Oracle on this machine as I have no (and will never
> have) root access to production server.
It's possibly not relevant in your situation but... You don't need root
access to install your own DBD::Oracle. There's no reason why you can't
have multiple copies of a perl module installed. Just install it into a
different location and adjust PERL5LIB env var (eg) to find it.
Tim.