RE: DBIx::Recordset and Oracle

list tables or metadata queries usually go against
all_tables and all_tab_columns.

The method typically passes in a schema owner and a
table name. I have traced the equivalent jdbc method
before and there is usually a placeholder for the
schema owner so that you can make it equivalent to
user_tables.

The user you are connected to can see those tables,
otherwise they wouldn't be coming back in the results.

The problem isn't the queries performance I imagine,
it is that the query is returning much more data than
you actually want (which makes it take a lot longer
than it should).

That's the problem with all this generic wrapper
stuff. :) Database independence is extremely
overrated.


--- "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:

> 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.
>
>




____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs

.

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)