Re: Oracle and Dotnet

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Jun 2005 07:56:13 -0700
Message-ID: <1117810450.289893@yasure>

Larry wrote:
> 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

Well yes .NET is part of the problem. As you discovered not the entire problem ... but .NET is not the tool of choice with Oracle for the simple reason that Microsoft sees Oracle as a competitor.

I have personally seen Oracle inserts at 20,000 per second using Java ... so the rate is not being limited by Oracle assuming decent hardware.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Jun 03 2005 - 09:56:13 CDT