PxPlus User Forum

Main Board => Discussions => Programming => Topic started by: James Zukowski on October 24, 2019, 11:32:25 AM

Title: Memory File Speed
Post by: James Zukowski on October 24, 2019, 11:32:25 AM

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!

Title: Re: Memory File Speed
Post by: Mike King on October 24, 2019, 11:52:04 AM

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.