Memory File Speed

Started by James Zukowski, October 24, 2019, 11:32:25 AM

Previous topic - Next topic

James Zukowski

Does anyone know whether it would be faster to PURGE a memory file or CLOSE/reOPEN it? There are 2 keys and relatively few records (<50).

Thanks!
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services

Mike King

Likely the difference in time would be negligible. 

The CLOSE and the PURGE go through the same logic to free the memory assigned to the records.

The PURGE might be slightly faster simply because of the overhead to free and re-create the internal file header not to mention that the PURGE is a single directive whereas to CLOSE and OPEN sequence consists of two.
Mike King
President - BBSysco Consulting - http://www.bbsysco.com
eMail: mike.king@bbsysco.com