|
|
sybperl-l Archive
Up Prev Next
From: "Barry Pretsell" <bpretsel at gotadsl dot co dot uk>
Subject: RE: FW: ct_fetch slowness
Date: Mar 22 2005 7:40PM
Michael,
Thanks for the advice, I'll give it a go and report back.
regards,
Barry
-----Original Message-----
From: owner-sybperl-l@peppler.org [mailto:owner-sybperl-l@peppler.org]On
Behalf Of Michael Peppler
Sent: 22 March 2005 19:34
To: sybperl-l@peppler.org
Subject: Re: FW: ct_fetch slowness
On Mon, 2005-03-21 at 21:36, Barry Pretsell wrote:
> I'm trying to migrate from Perl 5.004_04 to Perl 5.8.0 on HPUX version 11.
> I have noticed ct_fetch runs slower, and I don't know why? Anyone any idea
>
> I have executed the same Perl script under both versions of Perl, in the
> following order (even the fact that the data returned may still be cached
> has not helped..)
Off hand I don't really know what might cause the extra time.
It would be interesting to see the same profiling done at the C level
(i.e. see stats for the actual ct_fetch() call in Client Library) in
both versions of OpenClient.
Another possibility is that Sybase::Simple 0.51 uses the "return a
reference" option of ct_fetch, while 0.54 doesn't (no, I haven't checked
if that's the case, but you can check the ct_fetch() call in ArrayOfHash
to see if it passes a "true" value as the second parameter)
Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
|