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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Tuesday, July 26, 2005 10:40 AM > To: dbi-users@perl.org > 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
