Subj : Nodediffs & db:s To : Jan Vermeulen From : Scott Little Date : Tue Jan 07 2003 07:53 pm [ 07 Jan 03 01:37, Jan Vermeulen wrote to Jesper Sörensen ] 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 / sysgod@sysgod.org] --- FMail/Win32 1.60+ * Origin: Cyberia: All your msgbase are belong to us! (3:712/848) .