Hi, I have a program testing connection pool performance in multi-thread context. I am using firebird 1.5 and .net provider 2.0.1.
I have a thread. The thread does "open-connection, insert-records, close-connection" for 20 times to insert different data into different tables, then loops back. Scenario 1: connection pool = true, max pool size = 1. 1. When one thread was spawned, it took 1.2 second averagely to finish one iteration. 2. When two threads were spawned (one right after the other), two threads started and finished one iteration at almost the same time, after 8 sec. Average execution time for one iteration is 4s ( = 8s / 2 iterations) Scenario 2: connection pool = true, max pool size = 2. 1. When two threads were spawned (one right after the other), two threads started and finished one iteration at almost the same time, after 2.5 sec. Average execution time for one iteration is 1.25s, which is similar to scenario 1, case 1. Question: In scenario 1, the average execution time for an iteration dropped from 1.2s to 4s when 2 threads competed for 1 connection from the pool. Is this a performance problem? Best, Sean ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
