I agree with @SilverWarior that using the "FetchOptions" is how to control the overall dataset operation. I also agree that in the default mode using the fmOnDemand for the "mode" should force the database to return the records from a database in batches based on demand.

@Uwe Raabe Thank you for pointing that option out, it will be very useful to set it to cmTotal to get the total number of records in the database. This will hopefully prevent the need to use the Last function to get the count.