I'm using DBI/DBD::Sybase (Perl 5.8 Solaris 2.9 Sybase OCS 1250_8) to insert multiple (100s) of records to a sybase database in a while loop and it appears that the memory consumption of the Perl process keeps on growing (as watched by the prstat or top utilities). Variations on how the inserts are done (e.g., stored procedures vs. direct sql vs selects within inserts) affect the rate of growth - but the growth is there nevetheless. This is true for older versions of DBD::Sybase (0.94 and 0.95) but also for the latest one (1.0). This seems to point at the possibility of a memory leak in DBD::Sybase since all Perl variables are local to the while loop and the database handle is destroyed at the end of the loop. Search on the Internet indicates that people used to have some problems with that in the past (e.g.,2 years ago) and some partial modifications to the C code of teh library have been posted but it would seem that the problem should be fixed by now. Any thoughts ?

In reply to Memory leak with DBD::Sybase ? by Anonymous Monk

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.