accessing huge number of records using ADO

[shaileng]

Dear All,

I am facing a problem is accessing huge number of records using ADO

I am opening a query which returns me 1 Lac records. I have chosen to open the record set REC1 in async mode so that I can continue with my other work on the screen. How ever I have to assign this recordset to a grid as its datasource, how ever to assign a datasource to a grid it needs to cycle it till EOF of recordset. and hence it will still execute the query in Sync mode

To over come this problem I have tried creating another recordset REC2 which will have only those records that have been fetch into REC1 at this point of time. How ever I cannot use set Rec2= Rec1 method to do this as it will still wait for REC1 to finish the query. I tried creating clone, getrows() also.

Can anyone suggest me how to assign a recordset with values of another recordset which is still executing asynchroniously.

Thanks

 

[nigelrivett]

You can always unbind the grid and populate it in code.
Maybe you would be better not retrieving all the records but just returning enough to display then paging - requesting each page from the server as another query.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.