in reply to fetch row or fetchall

You can still count the rows and only use the first 100: your loop could keep the first 100 but continue counting until fetching is complete. It's about the same as fetching all of them using a DBI fetchall call, but fetching would probably (but not necessarily depending on the underlying database driver) use more memory in your application.

Replies are listed 'Best First'.
Re^2: fetch row or fetchall
by pg (Canon) on Nov 09, 2004 at 21:08 UTC
    "your loop could keep the first 100 but continue counting until fetching is complete"

    I would rather do a seperate query for count(), for performance. Although you are skipping, not using the fetch result, they still get transferred across, and waste band width.

[reply]

In Section Seekers of Perl Wisdom