ADO with Jetengine very slow?
-
We are using ADO(in a C++ env.) to connect to diffent databases just by replacing the provider string. What we noticed is that the ADO/OleDB Provider for JetEngine (4.0 and 3.51) (Access) is very, very slow. We compared with the the ADO/OleDB Provider for MS-SQL and we found a factor 60 !!!. We tried with old DAO MFC - Classes with Access-databases and the factor was 100 faster than with ADO/OleDB with JetEngine. Just using plain OleDB didnt make things much faster. Do someone know more about slowliness of OleDB for Jetengine? Are there alternative OleDB drivers that are faster? :confused: zack
-
We are using ADO(in a C++ env.) to connect to diffent databases just by replacing the provider string. What we noticed is that the ADO/OleDB Provider for JetEngine (4.0 and 3.51) (Access) is very, very slow. We compared with the the ADO/OleDB Provider for MS-SQL and we found a factor 60 !!!. We tried with old DAO MFC - Classes with Access-databases and the factor was 100 faster than with ADO/OleDB with JetEngine. Just using plain OleDB didnt make things much faster. Do someone know more about slowliness of OleDB for Jetengine? Are there alternative OleDB drivers that are faster? :confused: zack
Try to use client cursors instead of the default serverside cursors if the .mdb file is on your local pc: _RecordsetPtr pSet(__uuidof(Recordset)); pSet->CursorLocation = adUseClient; pSet->Open(...);