We have a large system which database is based on DB2 on OS/390. What we do is, when the application starts, we call a CICS module that sweeps the 100+ table database and returns a "recordset" of relevant information for each table that is then processed by the user level using ADO/DAO filters. This is rather clumsy, but it's by far more efficient that querying the database for each single program need (we do many million application runs a day). What's awful with it is the poor design of the application level, where there is no central repository for common useful routines and each programmer in a developer team of 30 to 50 people re-invented the wheel.... often with a variable number of sides :-)

Jus to stay on the off-topic side of life, we also had a number of memory leaks found, because the whole project was designed by some Smalltalk "expert" and the implemented in Visual Basic (!), and we kept on discovering weird pointers problems and memory leaks all around.

In reply to I work in one such shop by l3nz
in thread The crime under reusability by pg

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.