FW: ct_fetch slowness

"Barry Pretsell" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.