Let me preface this by saying I'm pretty new at Perl - please don't flame me for being stupid :)

I am writing a web-based inquiry module to a Win32 package we developed. I have used DBI and Apache in the past to whip up some pretty slick web pages with Perl, but nothing of this scale. Each search can potentially yield several thousand results, which will be displayed to the user in chunks of about 50 results. I would think that executing the entire search each time the user moves between the pieces of the result set (for example, from results 1-50 to 51-100) would be very slow and inefficient. I was wondering if there was some way that I could keep that result set around so that clicking "Next" would simply show me the next 50 results, and not execute the query again.

Any help is greatly appreciated :)

In reply to Using large result sets from a database by MrCromeDome

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.