I have to connect to a MDB file to insert data. DI uses jackcess library and it takes too long to insert data. I'm trying to insert about 2 millions rows (600MB) and it takes about 22 hours. I tried changing the "commit every" setting to a number larger than 2 millions and it reads the rows quickly, but then it takes too long to insert the data to the file.
Reading the jackcess FAQs, they say: "By default, "autoSync" is enabled, which keeps the database file in a more consistent state, but can be very slow for large updates. Disabling "autoSync" can dramatically increase update speed, but exceptions during update can leave the file in an unusable state (when disabled, you can call Database.flush() manually to force updates to disk). Modifying this option essentially trades off speed for recoverability."
Now I'm looking for a way to change this setting to this library on TOS DI. Another thing that strikes me is that the MDB file does not lock, I mean, there is no .ldb file when TOS DI is using it.
