Re: Oracle and Dotnet

From: Larry <larry_at_larry.com>
Date: Fri, 03 Jun 2005 14:37:18 GMT
Message-ID: <yWZne.9769$_o.1112@attbi_s71>

Holger Baer wrote:

> You suffer the same problem that many developers suffer. You start out with
> a small benchmark, and instead of trying to learn something out of it
>(namely how to use Oracle correctly in the first place) you're prepared to blame
> anybody else.

I don't necessarily agree that I was "blaming" anybody.

Was I puzzled that the per second insert rate was at 40. Yes.

Was I disappointed that our companys contractors simply said that "dotnet" was the problem? Yes.

Anyway, my not knowing that Dotnet was autocommitting was the core problem. By changing the code to use a transaction, my insert rate went from 40 per second to 1250 per second. That's still not quite the 7000 per second I get in MySQL using Dotnet, or the 10,000 per second I get in Oracle when using SQLplus.

But it's a start. And a big one at that.

I thank you...and everyone in this forum that replied for your gracious help!

Larry Received on Fri Jun 03 2005 - 09:37:18 CDT