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: FW: ct_fetch slowness
Date: Mar 21 2005 8:36PM

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..)

Perl 5.004_04
=============
Sybase::Simple 0.51
Sybase::CTlib 2.1
(built against Sybase libraries in /opt/sybase/open1004_8069/lib)

extract from DProf -S

    DBConnection::ArrayOfHash x 1       12.62s = (0.00 + 12.62)s
      Sybase::Simple::ArrayOfHash x 1   12.62s = (6.05 + 6.57)s
        Sybase::CTlib::ct_fetch x 71603         5.63s
        Sybase::CTlib::CS_TRUE x 71601          0.81s
        Sybase::CTlib::ct_results x 6   0.12s
        Sybase::CTlib::ct_execute x 1   0.01s
        Sybase::CTlib::CS_STATUS_RESULT x 2     0.00s
        Sybase::CTlib::CS_SUCCEED x 7   0.00s
        Sybase::CTlib::ct_fetchable x 5         0.00s
        Sybase::Simple::cleanError x 1          0.00s


Perl 5.8.0
==========
Sybase::Simple 0.54
Sybase::CTlib 2.16
(built against Sybase libraries in /opt/sybase/r1251/OCS-12_5/lib)


    DBConnection::ArrayOfHash x 1       28.43s = (0.00 + 28.43)s
      Sybase::Simple::ArrayOfHash x 1   28.43s = (17.44 + 10.99)s
        Sybase::CTlib::ct_fetch x 71603         10.53s
        Sybase::CTlib::CS_TRUE x 71601          0.37s
        Sybase::CTlib::ct_results x 6   0.10s
        Sybase::CTlib::CS_STATUS_RESULT x 2     0.00s
        Sybase::CTlib::CS_SUCCEED x 7   0.00s
        Sybase::CTlib::_attribs::FETCH x 1      0.00s
        Sybase::CTlib::ct_execute x 1   0.00s
        Sybase::CTlib::ct_fetchable x 5         0.00s
        Sybase::Simple::cleanError x 1          0.00s = (0.00 + 0.00)s
          Sybase::CTlib::_attribs::FETCH x 4    0.00s


Any information or advice would be greatly appreciated.

regards,

Barry