Connection Performance problem
Posted: Thu 23 Oct 2008 21:33
Hello,
I'm evaluating UniDirect for migrating a .Net 2.0 Windows Application that previously used SQLServer.
Now I want it to support multiple databases, so I changed all my code with the UniDirect DataProvider.
I'm having a performance problem when running several queries:
The program runs about 300 queries fine (and fast). For each query a new connection must be opened, as they run in different functions.
Then the program halts for about 10 seconds, and then it starts running again fast, for another 300 or so queries, when it stops again.
I've pause the debugging in the waiting-time, and I see that the delay is in the function open() of the UniConnection. It takes a LOT of time to get a connection after several queries.
I looked on the FAQ and thought the problem was about the Connection Pooling, but I disabled it in the Connection String ("Pooling=false"), but the problem persists.
Does somebody knows about this problem?
I'm evaluating UniDirect for migrating a .Net 2.0 Windows Application that previously used SQLServer.
Now I want it to support multiple databases, so I changed all my code with the UniDirect DataProvider.
I'm having a performance problem when running several queries:
The program runs about 300 queries fine (and fast). For each query a new connection must be opened, as they run in different functions.
Then the program halts for about 10 seconds, and then it starts running again fast, for another 300 or so queries, when it stops again.
I've pause the debugging in the waiting-time, and I see that the delay is in the function open() of the UniConnection. It takes a LOT of time to get a connection after several queries.
I looked on the FAQ and thought the problem was about the Connection Pooling, but I disabled it in the Connection String ("Pooling=false"), but the problem persists.
Does somebody knows about this problem?