When moving my DB2 database from system running SUSE to one running Fedora Core 6, I have noticed a surprising slowdown of perl accessing that database as follows:
  • Find the same row 10,000 times: 2x slower
  • Read 100,000 rows: 10x slower (!!)
    A devastating slowdown...

    Both computers have a dual core "Intel Pentium D CPU 2.80GHz" processor and I am using DBIx::Class (0.08003, most recent) to access a DB2 database (V9.1).

    Now I have noticed that SUSE comes with perl compiled for the i586 architecture, while Fedora Core uses perl for i386. So I have installed the following i586 packages from the SUSE repository on my Fedora system:
  • perl perl-DBI perl-Net-Daemon perl-PlRPC
    Then I have recompiled DBD::DB2 and now the queries on the Fedora system run almost as fast (10-20% slower) as on the SUSE system. I hope this is a helpful solution for others, even though it seems somewhat random.

    Did someone experience similar problems? Does this have to do with SUSE vs. Fedora builds or with i386 vs. i586 builds?

    In reply to DBI/DB2 slow on Fedora, fast on SUSE by hrr

    Title:
    Use:  <p> text here (a paragraph) </p>
    and:  <code> code here </code>
    to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.