Batchupdates performance


Hi there

More batchupdate related nonsense again, anyway here goes.

I have a dataset open for batch updates ctstatic & ltBatchoptimistic, I update multiple records with 35 new fields per record.

After I have walked the recordset and updated all required records I perform an updatebatch command, this seems to take forever approx 3.5 mins for 500 records, however the actual updates on the dataset are lightning fast < 1 sec.

This is all in Delphi 5, oracle 10G D/B, ADO connected via oracle oledb, TADOdataset is set to clUseClient, ctStatic, ltBatchoptimistic, any thoughts as to why the updatebatch command takes so long ???
.