As the cache file becomes large, performance is dramatically reduced

Hi

As the cache file becomes large, performance is dramatically reduced.

This can be produced by:
1) Opening 2 cursors
2) Do many tasks on cursor 1
3) Cache file is very large
4) Do performance test on cursor 1
Note that the same test as with an empty cache file can take double the amount of time.

Instead of holding all of the changes, the cache file should only hold the required information for each open cursor to get up to date in one step.

This also means that as work is done on the open file the performance won't degrade it will be the same.

Andy