Forum Discussion

Copper Contributor

Aug 02, 2024

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 (...

Copper Contributor

Aug 05, 2024

I have modified my test code with your suggestions...and i have 8 sec...thats really better...
My VB code takes only 1 sec...
But let us not be more royalist than the king...I will apply this tomorrow, on the big software...
I hope that the user experience will be 'satisfactory'.

PS : Private Message ? Where ? (en Francais ca irait probablement encore mieux...LOL )

philippeillinger

Copper Contributor

Aug 08, 2024

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...

philippeillinger
Copper Contributor
Aug 11, 2024
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 !!!
- Tom_van_Stiphout
  Iron Contributor
  Aug 11, 2024
  > And i have read, that Microsoft don't continue ACCESS.
  Please post the link here.
  It is not true.
  - philippeillinger
    Copper Contributor
    Aug 12, 2024
    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