There's a DBI database handle attribute called "RowCacheSize", which can be set to "1" to "disable the local row cache" when calling connect(); I'm not familiar with Jnms::Database::Control::DatabaseManager, but if that is where the connect call is being made, that's where you'd want to check whether this parameter is being handled, and how you can control it.

(I don't know if this will solve your problem, but it looks like a good thing to try. I'm guessing the default is "0", which will "Automatically determine a reasonable cache size for each SELECT".)

UPDATE: The section in the DBI man page about RowCacheSize closes with:

See also the "RowsInCache" statement handle attribute.

There may be some situations where you want to control caching at the statement-handle level rather than the connection level. Having a row cache is usually a Good Thing, and disabling it indiscriminately might be a Bad Thing.

(Oops! Another update: I just noticed that "RowsInCache" is "readonly". Oh well, no cache control at the statement level. Good luck...)

In reply to Re: Mysql query cache and DBI by graff
in thread Mysql query cache and DBI by josh803316

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.