How many records stored in Dataset?

In VB.NET, the dataset stores records retrived from database in computer's memory. However if the underlying query fetches many records (say 1 million) how does dataset store so many records in memory? Is there any way to control how many records will be retrieved from database before dataset is disconnected from data source?

Thanx

hi
you can try using the top keyword in your sql query string where you can specify how many records to retrive.

AFAIK, top is not supported by all databases (eg. SQL Server supports it but Oracle doesn't). Also, I need a mechanism to retrive next set of rows in consistent mannter.

I think that this is an interesting subject. Is there any guru that can comment on this.

Using datasets is fast but what is the effect on resources when datasets records grow too large.

Is there a way of finding the best medium.