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