You don't need to return all rows to find out how many rows there are. What's wrong with COUNT()? It's useful, it's handy, and it's standard. It returns one nice number that tells you how many items matched your query: 

SELECT COUNT(*) FROM tablename;

[download]

One can also count by distinct values in a column, in case you don't want to show duplicates more than once. This would, in a hypothetical monthly log of purchases on an ecommerce site, tell you how many different customers made purchases no matter how many items they bought or how many separate times they checked out: 

SELECT COUNT(DISTINCT customer_id) FROM purchases;

[download]

When you're working with both Perl and some other language, it helps to see if the other language addresses your needs. In this case, SQL could save your server quite a bit of data transfer and memory usage.

In reply to Re: kickstarting a paged result set by mr_mischief
in thread kickstarting a paged result set by metaperl

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.