RE: DBIx::Recordset and Oracle

What takes so long for you? What query is being executed and what are the DB waits generated? Are you getting SYS owned objects as described in that old posting?

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Tielman de Villiers [mailto:tvilliers@xxxxxxxxx]
Sent: Tuesday, July 26, 2005 10:40 AM
To: dbi-users@xxxxxxxx
Subject: DBIx::Recordset and Oracle



I have the same problem as described here:
http://www.nntp.perl.org/group/perl.dbi.users/7343
(searching from Oracle databases take extremely long because
DBIx::Recordset tries to get metadata for all tables), even though
I use modern versions of DBIX::Recordset (0.26), the
DBI(1.40) and perl (5.8.0).

I have tried to set '!TableFilter' with the same values I feed to
'!Tables', but without luck. As a temporary measure I have changed #342
in DBIx/Database.pm to
"
my $ListTables = 0; ##DBIx::Compat::GetItem ($drv, 'ListTables') ;
"
which is not ideal, but works.

Any other suggestions?

Thanks

--tielman




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • Res: RE: RE: Problems changing from 1.30 to 1.42
    ... With DBI 1.30 it works just it is: ... >>This electronic message transmission is a PRIVATE communication which contains ... >>intended recipient, please be aware that any disclosure, copying, distribution ... >>sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: DBI->Connect returning UNDEF in cgi but not in standalone prog
    ... You are returning undef. ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: make problem
    ... Perl may be copied only under the terms of either the Artistic License or the ... This electronic message transmission is a PRIVATE communication which contains information ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)