I was looking around cpan for modules that would accomplish what I am looking for, but need a bit of advice. I have a script that queries a mysql db and returns the data into a web browser. Some of the queries can return thousands, to tens of thousands of records. I would like to write this data to a temporarily cache on the system. besides the data samples being so large, I would like the user to be able to sort columns and type in a "filter box" to slim down the results, but instead of querying the DB again, to sort and filter based on the cache. I saw Cache::FileCache but there wasn't much documentation and I saw in other threads it's very slow. I was hoping to find something well documented and possibly small examples to help me understand better. Thank you for any suggestions on how to accomplish this task.

In reply to Best way to cache large amount of data? by hallikpapa

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.