On Sep 8, 2006, at 11:26 AM, Reidy, Ron wrote:
Did you run 10046 traces on the code?
Have you profiled the code?
I switched to these same versions a couple of years ago, and have
had no
problems.
rr
-----Original Message-----
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 9:04 AM
To: dbi-users@perl.org
Subject: switching perl version
A perl program executing in linux Redhat 7.0, perl version 5.6, oracle
8i was
using 30% cpu approx. Now I'm running the same program in linux
enterprise ES 4,
perl v. 5.8.5, Oracle 10g. uses 60% cpu. I'd like to know what's
happening
because the performance is slower and the difference is wide big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.
You've changed every aspect of your system. I think Ron's good
suggestions are a minimum in terms of researching why the
performance is slower. Perl is about the last place I'd look.
As for the cpu numbers, higher % cpu should tranlsate to faster
performance, everything else equal, which it's not in this case.
In particular, I'm told by our sys admin that the Linux 2.4 kernel
(i.e. RH 7.0) reports CPU differently than the 2.6 kernel (i.e. ES 4).
And I/O scheduling has changed.
But this is pretty far off topic for the DBI list.
-Chris
