lob writing performance issue
Posted: Thu 02 Jul 2009 05:46
Hello,
I want to optimize the performance, when writing lob values to the database. The Odac help says that I should change MemData.DefaultPieceSize, but this is declared as a const
Standard transfer rate is around 300-500kb/s in a 100MBit network.
When changing the value to 512k within the debugger, I can improve the performance to more than 2Mb/s, but only in oci mode. Direct mode does not seem to consider DefaultPieceSize, the piece size seems to be fixed around 32k (standard DefaultPieceSize/2?) and performance stays at 300-500k/s:(
Is it possible to improve writing performance in direct mode? Why is DefaultPieceSize ignored in direct mode?
Reading performance seems to be good in both modes.
I want to optimize the performance, when writing lob values to the database. The Odac help says that I should change MemData.DefaultPieceSize, but this is declared as a const
Standard transfer rate is around 300-500kb/s in a 100MBit network.
When changing the value to 512k within the debugger, I can improve the performance to more than 2Mb/s, but only in oci mode. Direct mode does not seem to consider DefaultPieceSize, the piece size seems to be fixed around 32k (standard DefaultPieceSize/2?) and performance stays at 300-500k/s:(
Is it possible to improve writing performance in direct mode? Why is DefaultPieceSize ignored in direct mode?
Reading performance seems to be good in both modes.