TUniLoader and multithreading

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
martin.trummer
Posts: 19
Joined: Mon 12 May 2014 14:16

TUniLoader and multithreading

Post by martin.trummer » Mon 12 May 2014 14:22

1) I guess when I insert data into e.g. 3 tables, I should use 3 threads where each thread has a TUniConnection and a TUniLoader for max. performance, right?
2) will this approach also increase performance (or work at all) when I have e.g. 2 threads, each with a TUniConnection and a TUniLoader, that insert data into the SAME table?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: TUniLoader and multithreading

Post by azyk » Wed 14 May 2014 13:40

Data insert in separate threads can increase performance, as well as data insert in the same table. But you should take into account, that performance won't depend on UniDAC in both cases, but on what database you are working with, on the server configuration, etc.

You can test performance by yourself and find the best solution for each particular case.

Post Reply