Record lock issue when performing lookup within current file

Kenneth Brody kenbrody at spamcop.net
Fri Jun 17 09:56:52 PDT 2016


On 6/17/2016 11:36 AM, Nancy Palmquist via Filepro-list wrote:
[...]
> if you do a new lookup to that file, you have to reconnect.  You will find
> that in a posting processes, issuing a WRITE instead of a CLOSE on each
> record will speed up the process in a noticeable way.
[...]

That's true in most cases.  Note, however, that this particular case is a 
lookup to the current file, which has much less overhead than a lookup to 
some other file.  (The map has already been parsed, and all of the pieces 
are already open.  These resources are shared with a lookup to the current 
file.)

-- 
Kenneth Brody


More information about the Filepro-list mailing list