sybperl-l Archive

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