|Subject||Re: [firebird-support] Simultaneous inserts / selects|
When you start a lot of instances of one application - it's like multi-threading, it is slower than one inctance? )
If you want use multiple thread you must to try do it, than analyze errors and do it again, until results became good )
do you have any experience in selecting from / inserting to table from multiple threads? Is it faster in comparision to one thread which selects / inserts data in queue?
What is your opinion on this? My gut tells me that it will be always slower in comparision to single thread. But maybe I am wrong and it is worth the hassle to use separate threads?
Assumption here is that each thread pulls of data with different primary / secondary keys and also inserts with different keys.
I would like to hear your opinion about this topic.
-- Regards, Markov Dmitri