If sqlite isn't caching already, the operating system is.

In real application I'm using postgres, but yes, you're absolutely right, 10000 additional requests can't take 15 seconds, I had to think about it, thanks. I ran it with Devel::NYTProf and have found that it spends a lot of time inside Class::Accessor::Grouped and inside various DBIx::Class modules, but not in DBI and DBD::SQLite. So I guess this overhead is caused by creating resultsets for 'Artist'. Pity.

Is this an optimization that makes sense to look for?

Sure. I'm reworking log processing application, that has serious performance problems, and hoped to replace current DB abstraction layer with DBIx::Class, as our current custom module is not very flexible and would require a lot of work after I fixed a DB scheme.

Concerning your last statement, generally I would agree with you, but in this case I know there the hot spots will be and I prefer to avoid them by spending some time on benchmarking and experimenting before I'll be limited by existing program structure. I think it will save me some time from these 95% in the end, so I could spend it here :)

In reply to Re^2: DBIx::Class. Cache table in memory by zwon
in thread DBIx::Class. Cache table in memory by zwon

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.