I queried 8000 data rows into a dataview and inserted
them row by row into an empty table. The managed
provider needed 350 seconds, but the .NET ODBC Driver
needed only 78 seconds.
I put all the code I was using in one file (see attached).
Usually the Lib code and the connection code is outside i a
dll, but this should not make any difference.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is due to connection pooling. when inserting 1000
records using MySQLOleDB and the OLEDb.net provider, I
get 11 seconds versus 67 seconds with my provider. I am
actively working on implementing connection pooling and
should have it out in the next week or so in version 0.70.
This will level things up a bit.
Thanks for using the driver and submitting issues. It's people
like you that take the time to let me know about issues that
make open source really work.
Reggie
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: NO
Can you send me a snippet of code or pseudo code showing
how you are calling the provider? THis will help me track
down the issue.
Thanks
Reggie
Logged In: NO
Also, was this using version 0.65 or 0.68?
Reggie
Logged In: YES
user_id=609557
Hi,
I was using the version 0.68.
I put all the code I was using in one file (see attached).
Usually the Lib code and the connection code is outside i a
dll, but this should not make any difference.
Logged In: YES
user_id=523261
This is due to connection pooling. when inserting 1000
records using MySQLOleDB and the OLEDb.net provider, I
get 11 seconds versus 67 seconds with my provider. I am
actively working on implementing connection pooling and
should have it out in the next week or so in version 0.70.
This will level things up a bit.
Thanks for using the driver and submitting issues. It's people
like you that take the time to let me know about issues that
make open source really work.
Reggie