pbprathi
Newbie
Joined: 20 Apr 2006
Posts: 2
|
 Posted: Apr 20th, 2006 07:24 AM Post subject: Recordset to binary file |
 |
|
hi
i am using SQL Database and retriveing large data which sometimes could be millions of records. The data from the recordset is taken into files in binary format for subsequent display. The process of accessing data from recordset and writing to files is taking a few minutes depending on the size of data. I am using like this
While rsMap.EOF = False
Put IndexHandle, , ENTCODE
Put IndexHandle, , EntName
Put TextHandle, , ENTCODE
Put TextHandle, , EntName
Put IndexHandle, , entcol
Put IndexHandle, , Ent_Textx
Put IndexHandle, , Ent_Texty
Put TextHandle, , Ent_Textx
Put TextHandle, , Ent_Texty
rs.movenext
wend
Can someone tell me if there is a better way of retrieving data from recordset so that retrieval is faster. For example I am currently getting one record each time instead can I pull a bundle of data at a time. Or any other method.
thanks |
|
