Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- SIx Driver RDD v3.00 - Reference Guide - <b>fpt/smt memo files reuse discarded blocks:</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
  FPT/SMT memo files reuse discarded blocks:

  Unlike Clipper or FoxPRO, the SIx Driver keeps a "free block" list in the
  header of its FPT/SMT memo files, which lets it know which blocks within
  the file have been freed.  Blocks can be freed up either by simply deleting
  the associcated record in the DBF file, or by adding enough data to the
  memo that makes it require more blocks than it's already using.

  For example, with Clipper's DBT memo files, if you have just the word
  "Bogus" stored in a memo field, that tiny little five byte word is taking
  up 512 bytes!  That's the block size used by Clipper's DBT files.  Now,
  if you delete that record, those 512 bytes do not get deleted from the
  memo file, even if you do a PACK.  Also, if you add another 600 characters
  to that memo field, they no longer fit into that one block.  Unless you're
  lucky, and that was the last block in the memo file, Clipper abandons that
  block, and moves all 605 of those new bytes to two new 512 byte blocks at
  the bottom of the memo file.  Now that old 512 byte block is laying around
  making your DBT file fatter than it was before.

  Well...not only do the SIx Driver's FPT/SMT memo files use default block
  sizes of 32 and 1 (respectively) to reduce excess memo bloat, but it also
  will automatically check the "free block list" in the memo file header
  for an abandoned block to reuse before adding a new one to the bottom of
  the memo file.  Cool, eh?

  And, if you happen to free up more blocks at one time than the SIx Driver
  can keep track of in the header (about 80 or so), we have even provided
  you with the handy MEMOPACK command or the Sx_MemoPack() function.
  These work on DBT memo files as well as on FPT and SMT memo files.


See Also: MEMOPACK Sx_MemoPack() Can perform a PACK on FPT/SMT/DBT memo files

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson