Forum Discussion
ADODB performance problem
Hi All, (Win10, Win11) To highlight a performance problem (with ADODB/ACCESS), on a heavy client, I wrote two small programs one in VB.NET (and VBA), the other in CPP/MFC. Using the same component (...
My problem is solved !!!
It was a parameter problem...
ALL the sample code (and API), use the adUseClient parameter, and that is the problem !!! Using adUseServer, drops to 2sec, the duration !!!
In VB.net adUseServer is the default option !!! And that is the answer, that explain the difference
!!!
Regards...
It was a parameter problem...
ALL the sample code (and API), use the adUseClient parameter, and that is the problem !!! Using adUseServer, drops to 2sec, the duration !!!
In VB.net adUseServer is the default option !!! And that is the answer, that explain the difference
!!!
Regards...
And i have read, that Microsoft don't continue ACCESS...
I have found an open source issue...Sqlite / ADO...the performance are identical...but just be care to put a transaction !!!
I have found an open source issue...Sqlite / ADO...the performance are identical...but just be care to put a transaction !!!
- > And i have read, that Microsoft don't continue ACCESS.
Please post the link here.
It is not true.- You’re almost right
But the question I ask myself...why did Microsoft abandon DAO, in this case? And especially not have offered an x64 version ?
the link : https://www.comparitech.com/net-admin/microsoft-access/
But, I agree, we find good and not good on the net...
Regards
