Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: FW: ct_fetch slowness
Date: Mar 22 2005 7:34PM

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 Peppler  -  -
Sybase DBA/Developer
Sybase on Linux FAQ: