Howdy!

It's not clear from your question whether or not you need the total number of rows the query might have returned.

If you need the first 100 rows from a query that could return several orders of magnitude more rows, do the fetchrow 100 times and then ->finish the statement to tell the server it can pitch the remainder.

If you also need the total number of rows the query would have returned, do that as a separate step using count().

If your original query would have returned only 101 rows, you don't save, but you don't get hammered the way you would if you went ahead and fetched all 10,000 rows even if you only needed 100.

If you are doing two different things, you probably want two separate queries. If performance becomes an issue, you can optimize each separately, with the different aims not getting in the way of each other.

yours,
Michael

In reply to Re: fetch row or fetchall by herveus
in thread fetch row or fetchall by hakkr

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.