PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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