Access database slow 关注
I've an Access database (accdb) on a network share with around 1 million of records.
I'm using Bartender 2016 to access it without any problems. When I access the records through the Bartender file, it takes 1 seconds to show the selected record with a filter.
When I am using 2021 version, it takes 30 secondes to access the same database with the same bartender file and same filter.
Have you already experienced this issue ? I've followed this KB https://support.seagullscientific.com/hc/en-us/articles/360023695493-How-to-fallback-and-force-BarTender-to-use-the-Microsoft-Access-Database-engine-driver-OLEDB-JET-in-BarTender-2019-and-later but it's not working...
Thanks for your help.
PS : if I remove some records from the database, the time to access it decrease, that should implicate that a lot of data are read to access database...