Then I don't believe this is a dbi issue; most likely a difference in configuration at the Oracle client or OS level.
Where does the database reside (what machine) ? What is the configuration of each machine as far as CPU, memory, etc? Does the Unix machine have anything else running on it? What is the output of 'sqlplus -v' on each machine? This is getting off-topic for this DBI list, I believe. -Joe --- John-Thomas Beadles <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
