Performance in disconnected recordset
Posted on 2001-06-07
We are doing highly database intensive calulations.
We are fetching millions of records and doing calculations in loop and updating/inserting records in tables.We have created indexes and views to improve the speed and we are able to achieve 80000 records in 8 minutes.
But now same stored procedures are required to be imlplemented in COM using batch processing (disconnected recordset).
We are calling batchupdate of recordset to updates after calculations are done in COM.BAtch Update is taking more time and as a result its taking huge time. Why batch update takes so much time.
Can we improve performance of disconnected recordset