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

Reply via email to