Hi, 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. Thanks you.