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

André Hartmann wrote:

[snip]
>
> What I have is this:
>
> Oracle Server: 9i, Win2000, 1GHz, 1MByte, one test instance running. Not
> swapping. Data file that the LOB is going to is on an IDE hard disk. Nothing
> else doing.
> Oracle Client: 9i, Win2000, 1GHz, 1Mbyte, nothing else doing. LOB data not
> read from file (so hard disk is no issue here) but generated randomly in
> main memory while running (chunks of 32kb).
>
> Both are connected via a TCP/IP ethernet 100MBit/s.
>
> I have a table "LOBTest" which has a string key column and a BLOB column.
> I insert a row with an empty_lob and then get a lob locator and stuff
> 10.000.000 bytes (so roughly 10MB) into the lob locator.
>
> What I get is it takes around 25 seconds with my appl built in RELEASE
> mode (VC++) and 35 seconds when build in DEBUG mode. During that time period
> no significant load is incurred on any of the computers (i observe with task
> manager) nor is the network a bottleneck (my network admin monitors with a
> tool that shows no collisions).

[snip]

Do the math:
10MB/25 secs == 4MB/sec == 40Mbps
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, etc, etc.
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?

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

-- 

Regards,
Frank van Bortel