Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LOB-insert performance: is 25secs for 10Mb okay ?

Re: LOB-insert performance: is 25secs for 10Mb okay ?

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Mon, 16 Aug 2004 16:36:06 +0200
Message-ID: <4120c657$1@olaf.komtel.net>


> Do the math:
> 10MB/25 secs == 4MB/sec == 40Mbps

  uh ? what math's is that ? 10MB = 10*8 Mbit = 80Mbit. Rate: 80Mbit / 25sec = 3.2Mbps, at least with my calculator...

> That is _without_ taking in consideration any overhead
> regarding setting up network connections (how's your
> DNS performing?!?), opening threads, opening file(s),
> buffering (how large is your LOB buffer?), TCP overhead,

  client side lob buffering is not enabled. is there a server side lob buffering ?

> I guess when taking all that in account, you may well
> hit your network max throughput of 100Mbps during the
> actual transfer... Perhaps you can work out how long
> the actual transfer takes? E.g. by sinking it to
> /dev/null?

  i am on windows. no /dev/null there, right ? what do you mean ? should i compare a simple filesystem-to-filesystem copy to get an idea how much of the performance is taken by tcp/ip, ports, hard disks ? I tried that. A file of 18MB copies from one computer to the other in 3 secs, so that's roughly 48Mbps.

>
> There seems a lot of overhead in the VC++ code... Is
> there a PERFORMANCE mode ?

  I compile my application in DEBUG and RELEASE modes ... both results I gave. Of course it is faster in RELEASE mode (which is what i would deliver to the customer): 25sec. I got 35sec in DEBUG mode.

AH
:) Received on Mon Aug 16 2004 - 09:36:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US