Page 1 of 1

TUniLoader and multithreading

Posted: Mon 12 May 2014 14:22
by martin.trummer
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?

Re: TUniLoader and multithreading

Posted: Wed 14 May 2014 13:40
by azyk
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.