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?
TUniLoader and multithreading
Re: TUniLoader and multithreading
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.
You can test performance by yourself and find the best solution for each particular case.