Hi.
I have to create several mdb files. I use own thread for work with 1 mdb file. But I noticed, that threads blocked each other many times. As I can see the reason - class UcanaccessConnection use sync by class methods. And if one thread commit something, others waits even if works with different files. is it possible to avoid blocking problems for differend databases?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Currently not. But you're right I may sync on a single file object. I didn't think of this situation that is very unlikely, you must have a number of concurrent massive transations on multiple files. Maybe next version.
Last edit: Marco Amadei 2018-07-28
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi.
I have to create several mdb files. I use own thread for work with 1 mdb file. But I noticed, that threads blocked each other many times. As I can see the reason - class UcanaccessConnection use sync by class methods. And if one thread commit something, others waits even if works with different files. is it possible to avoid blocking problems for differend databases?
Currently not. But you're right I may sync on a single file object. I didn't think of this situation that is very unlikely, you must have a number of concurrent massive transations on multiple files. Maybe next version.
Last edit: Marco Amadei 2018-07-28