I'm working with ADO connecting to SQL Server 2005.

My TADODataSet selects 1 million records. using a TDBGrid and setting the `TADODataSet.CursorLocation` to `clUseServer` works. but the TDBGrid chokes!

How can I select 1 million records, avoid paging, and still be able to display records in the grid without fetching ALL records to the client side, letting the Grid read ahead as I scroll up and down?

SQL enterprise manager can execute a query and select 1 million records asynchronously without any problems (also MS-ACCESS).