And the jury's in. Dropping the NOTE_PAD from 50 to 10 percent took the RELOADed database from 1.8 gb down to 1.4 gb...only 200 mb greater than the PACKed database. This is a windfall discovery in terms of staying away from the 2gb limit for our legacy system. And if push comes to shove we could disable PADing altogether...
Thanks for the help guys, Steve ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, March 29, 2007 9:26 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Pack vs. Reload << My guess is that there is a difference in the way the commands are using the current 'NOTE PAD' settings to anticipate the need for space within note blocks in (future) editing, without having to move whole rows to the end of a file. >> I don't believe that PACK uses the NOTE_PAD setting at all. It simply takes the current row data as it exists on disk and moves it "back" over any unused (deleted rows) space that precedes it. NOTE_PAD is used when 1) a NOTE exceeds the allocated space and the row has to be rewritten to the end of the datafile and 2) You RELOAD a database or LOAD new data into a table with a NOTE column. In both those cases the new row is created with the specified padding. -- Larry
