Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LOB-insert performance: is 25secs for 10Mb okay ?
> 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