Question

Multithreading when working with database

10:22 Sep 29, 2020

I'd like to use Parallel to do some database tasks. But when I follow this article, I see that the second example is one thread only.

https://academy.creatio.com/documents/technic-sdk/7-16/multithreading-w…

How should I do to work with multithreading?

3 comments

Olga Avis

12:09 Sep 30, 2020

Hello Van Ly,

Using several streams in working with the database via UserConnection may cause issues in starting synchronization or committing transactions. You cannot call the DBExecutor instance methods in the parallel threads. It is recommended to make sure that the call of DBExecutor instance methods is performed consistently in one thread.

Please, let us know in case any further information is required.

Best regards,

Olga.

Van Ly

11:56 Oct 02, 2020

Olga Avis,

Yes I known it. Does it mean that we cannot use multithreading in any way?

Olga Avis

10:31 Oct 05, 2020

Dear Van Ly,

It is strongly not recommended since it could cause further system failures.

Best regards,

Olga.

Show all comments