The query ran in 9 minutes on SQLplus on the UNIX machine in question (talking across to the remote target DB). The same query ran in under 1 min on the PC.
-----Original Message----- From: Joe Raube [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 Also, did you execute the query using SQL*Plus on each machine and note the performance? -Joe --- Joe Raube <[EMAIL PROTECTED]> wrote: > Are the versions of perl, dbi, dbd, and the Oracle client the same on > both machines? > > What OS is running on each machine? > > -Joe > > --- [EMAIL PROTECTED] wrote: > > > > If you are doing selects, you can set the $dbh->RowCacheSize, > > perldoc DBI will tell you what you need to know. > > > > On 02-Oct-2002 John-Thomas Beadles wrote: > > > Help! I'm having a severe performance problem with a Perl > > program talking > > > to a remote Oracle database. I've read the DBI & DBM perldocs, > > the O'Reilly > > > book and can't access the DBI faq. > > > > > > To characterize the problem, I've created a small, > transportable > > program > > > that will run on my PC and on the UNIX workstation where the > > program has to > > > run. The program completes in about 20 seconds on my PC, and > > about 20 > > > minutes on the UNIX workstation. The program pulls approx. 38k > > records from > > > a 1.2M record table. On both, the query appears to prepare and > > execute > > > promptly. The problem appears to be fetching the data to the > > client. I did > > > a trace that shows the issue. It seems to just take a long > time > > to do all > > > these fetches to get the results. Is there anything > configurable > > in DBI > > > that could affect this? The UNIX server is a multi-processor > > machine, low > > > CPU utilization, though the disk gets a good workout. > > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
