Re: fetch row or fetchall

[steves]

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.

[pg]

"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.