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
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]
: [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
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
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Are the versions of perl, dbi, dbd, and the Oracle client the
same on both
machines?
What OS is running on each machine?
-Joe
, October 03, 2002 10:09 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
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
[RICH1:2795:EXCH]; [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
If you're still running HPUX 10.x, I'm guessing that it's also an older
machine? It's probably not a memory issue, since SQL*Plus won't store the
38K rows in memory. There's some memory use, but it's
Ah yes, there was a bug in DBD::Oracle. I forget which version numbers, you can add my
$foo =
$sth-{NAME} before the $sth-execute which will start the caching. Which version
of DBD::Oracle are you using?
.. Not that this affects performance, but you can set your sql by,
my
Hm, I'll try that. However, the listener appears to be down now, so I can't
try it just yet.
Not sure about the DBD Oracle version, not sure how to find the physical
module. Is there another way to tell?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Ah
perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION, \n'
On 03-Oct-2002 John-Thomas Beadles wrote:
Hm, I'll try that. However, the listener appears to be down now, so I can't
try it just yet.
Not sure about the DBD Oracle version, not sure how to find the physical
module. Is there
Thanks. v1.03 on the Unix side, v1.8 on the PC.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:02 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
perl
:02 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION, \n'
On 03-Oct-2002 John-Thomas Beadles wrote:
Hm, I'll try that. However, the listener appears to be down
PROTECTED]]
Sent: Thursday, October 03, 2002 11:13 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
I'm sure you are aware of this, but the DBI/DBD::Oracle are very old on that
server.
On 03-Oct-2002
Bingo, we have a winner! I've alternated including this statement, and it
definitely appears to be the key, at least for this test code. Now I have
to go modify my production code. I'll let you know if it works the same
way.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Make sure you're using the latest DBD::Oracle.
Send a trace(8) log - just the part from prepare thru execute.
Tim.
On Wed, Oct 02, 2002 at 05:45:01PM -0500, John-Thomas Beadles wrote:
Help! I'm having a severe performance problem with a Perl program talking
to a remote Oracle database. I've
Why can't you access the DBI FAQ? www.xmlproj.com/cgi/fom.cgi
Ilya
-Original Message-
From: Tim Bunce
To: John-Thomas Beadles
Cc: [EMAIL PROTECTED]
Sent: 10/3/02 3:31 AM
Subject: Re: Performance problem with DBI, DBD-Oracle8
Make sure you're using the latest DBD::Oracle.
Send a trace
: Thursday, October 03, 2002 12:23 PM
To: 'Tim Bunce '; Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: '[EMAIL PROTECTED] '
Subject: RE: Performance problem with DBI, DBD-Oracle8
Why can't you access the DBI FAQ? www.xmlproj.com/cgi/fom.cgi
Ilya
-Original Message-
From: Tim Bunce
It's definite. I implemented it all through my code and dropped the
execution time from 40+ minutes to approximately 4.5 minutes. I've notified
the sys admin to the problem, see if we can implement a global solution.
Thanks a bunch, guys!
-Original Message-
From: Beadles, John-Thomas
Have him update your DBI DBD::Oracle to the latest versions.
(1.30) (1.12)
On 03-Oct-2002 John-Thomas Beadles wrote:
It's definite. I implemented it all through my code and dropped the
execution time from 40+ minutes to approximately 4.5 minutes. I've notified
the
PM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Have him update your DBI DBD::Oracle to the latest versions.
(1.30) (1.12)
On 03-Oct-2002 John-Thomas Beadles wrote:
It's definite. I implemented
20 matches
Mail list logo