Quickest way of inserting multiple CLOB's

[Arvid]

We do update a table with about 20000 CLOBs and hour.

Currently we are running 20000 "UPDATE" using a temporary LOB's.

Is there a faster way of doing this?

Because of the LOB (CLOB) I assume that "Array DML" can not be used - but some similar method would have been great...

Does it exist?

 

[Marco Kalter]

It depends on the size of the CLOB data. For large CLOB's, writing the CLOB data will probably be the bottleneck. For smaller CLOB's you may be able to speed things up with the TOracleDirectPathLoader component.