> It must be because of note padding. > When you add a note to the database it leaves some extra space in the note > field in case you go and make small changes to the note, it does not have to > move the record.
Troy: That was my first thought too but after looking it up on RSyntax my understanding is that the row with the NOTE is moved and repadded at update time, not at reload. If R:Base refigures the padding at reload, it's not clear from the docs. Still, I have to go with your opinion. One thing I never noticed about the NOTE_PAD setting is that the percentage is not of the current NOTE field length, but rather of the total row length. That means two things: 1. If the row is wide the amount of space added could be quite large. 2. If you change the length of the row (by adding fields) and the note padding is _not_ refigured during the ALTER TABLE command but is refigured during the reload, you could actually see a padding increase even if you haven't changed any of the note values (since the previous padding would now be less than 10% of the row length). -- Larry _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
