Subj : Nodediffs & db:s
To   : Jan Vermeulen
From : Scott Little
Date : Tue Jan 07 2003 07:53 pm



JV>     You get a new diff each week to update last week's nodelist. As
JV> long as you have kept your records in order (and why shouldn't you?),
JV> you move them to an auxiliary base record by record, inserting the new
JV> nodes as per the diff telling you Axx, copying where it says Cxx and
JV> skipping where it says Dxx. Then kill the old file and rename the new
JV> one to the old one's name.

Thats extra complication that wouldn't be necessary if updates specified the
node.  Line based updates also mean taking the table offline (totally
unacceptable) to do a complete copy/rename, using transactions (may not be
available), or a post-diff comparison of the old and new tables to determine
whats changed and update the live table accordingly (*shudder*).


-- Scott Little  [fidonet#3:712/848 / [email protected]]

--- FMail/Win32 1.60+
* Origin:  Cyberia: All your msgbase are belong to us! (3:712/848)