The question is what sort of data provider you'll become.

If the data provider is an SQL database, the WHERE clause must be applied to each record.

Multiple calls to the data provider must be made if the provided data buffer is insufficiently large.