RE: FW: ct_fetch slowness

Michael,

Thanks for the advice, I'll give it a go and report back.

regards,

Barry

-----Original Message-----
From: [email protected] [mailto:[email protected]]On
Behalf Of Michael Peppler
Sent: 22 March 2005 19:34
To: [email protected]
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  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html