PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Memory File Speed  (Read 1094 times)

James Zukowski

  • Diamond Member
  • *****
  • Posts: 297
    • View Profile
Memory File Speed
« 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!
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services

Mike King

  • Diamond Member
  • *****
  • Posts: 3811
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Memory File Speed
« Reply #1 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.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com