Icon View Incident Report

Serious Serious
Reported By: Rolf Frei
Reported On: 11/10/2001
For: Version 3.03 Build 1
# 959 Transaction Commit Time Longer than Necessary Due to Increased Flushing to Disk

The Database.Commit call needs much more time in DBISAM V3 than it takes in V2. So this code needs about 2 sec. in DBISM 2 while in DBISAM 3 it takes about 5 sec. and there is much more disk activity.

If I write the following, it is much faster. It is the same speed as in V2 or even faster. It looks to me as if the normal Commit does a flushbuffers on every record it writes to the disc. I don't think this should be this way.

tblHG.Database.Commit(False);
tblHG.FlushBuffers;



Comments Comments and Workarounds
The flushing wasn't always occuring on every record write, but in the worst case scenario it very well could.


Resolution Resolution
Fixed Problem on 11/11/2001 in version 3.04 build 1
Image