Try looking at table buffering and using tableupdate(). Also, if I understand you correctly you probably need to implement some kind of record locking as well. Check rlock() lock() set multilocks etc.

HTH