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