I have no DBIC expertise, sorry.

Hopefully one of the grandees will answer here, I've send a PM to one of them.

> You can't memoize with a nested hash, as input, effectively can you?

Dunno!

Well the naive approach is to stringify the nested hash with Data::Dump or similar and to use it as a hash key.

But this will lead - like i said - to a lot of redundant data and you might need to free memory from time to time.

> I mean you can compare deeply but is that more efficient than hitting the DB?

IMHO only if you maintain index tables for key columns in hashes.

Like an AND condition being a hash slice of the two %indicies. OR a join of both %indices

But I'd guess there are already XS modules available offering in-memory SQL?

Does SQLite always operate on the filesystem?

Sorry im guessing here, I'm more an SQL user lacking deep knowledge.

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery

In reply to Re^3: Caching DB rows transparently and with SQL search by LanX
in thread Caching DB rows transparently and with SQL search by bliako

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.