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

   Quoting Scott Little on Tue 7 Jan 2003 19:53 to Jan Vermeulen:

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.

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

   I've never said you should do that on line. You can prepare all your files
in a separate operation and than swap them. Should take not more than a few
seconds on the kind of system you apparently use...


   -=<[ JV ]>=-


* Origin: The Poor Man's Workstation -- Wormerveer NL (2:280/100)

You are viewing proxied material from cvs.synchro.net. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.