Program is slow using ADO.Net
Posted on 2004-08-02
I am creating a program using VB.Net and an MS Access database. I was originally using ADO because I was familar with it but now I would like to use ADO.Net. To see how it worked I created the OleDbConnection and OleDbDataApter by using the DataForm Wizard. That all worked fine, but the program is very slow at loading the dataset when I try to debug the program. The database I am working with has over 12,000 records in it and I will be adding another database later to the project which will have at least double the records. Is the amount of records in the database what is causing the program to load the dataset so slowly and is there a way to make it quicker?