DAO
-
I would like to know whether VB5.0 supports DAO? Also I need to read more than 10,000 records from a file and hence manipulate it.Which is the best method of read available with VB 5.0?If i go for binary read, i need to use the OPEN method and if it is text read can i go for Filesystemobject? If it is a text read, which will give more performance, FSO or the open method? I am using a number of collections and classes in my application.Will it affect the performance? Can i be able to increase the performance by using DAO recordsets instead of Collections? Please give me a reply Thanks, Sripriya
-
I would like to know whether VB5.0 supports DAO? Also I need to read more than 10,000 records from a file and hence manipulate it.Which is the best method of read available with VB 5.0?If i go for binary read, i need to use the OPEN method and if it is text read can i go for Filesystemobject? If it is a text read, which will give more performance, FSO or the open method? I am using a number of collections and classes in my application.Will it affect the performance? Can i be able to increase the performance by using DAO recordsets instead of Collections? Please give me a reply Thanks, Sripriya
Hi 1) Yes DAO is available in VB 5 . ofcorse in VB 4 , DAO was the prefered way of working with databases . but why not to consider ADO which is also avaialbe under VB 5 2) I add another method , text file access as a OLEDB data source . it is a very convinient task using DAO . you will have all the luxery of ADO and Recordset in your program without a single line of code . I think it is more important to considet parsing speed of your file ( spliting in collections , sorting , ... ) than just reading speed . using ADO you can use ADODB::Recordset as a collection with sorting/parsing/searching capabilities . there is a great article on this topic in MSDN . 3) using VB code for parsing , searching or sorting is not as fast as you might desire . besides you have to do it all in your code . 4) Using DAO recordsets is a good choice too . but again you have to read the text file and parse as different fields , then write into recordset . use ADODB::Recordet to eliminate all these steps . I hope it would be of help