TIP: Click on subject to list as thread! ANSI
echo: net_dev
to: Scott Little
from: Jan Vermeulen
date: 2003-01-07 12:48:40
subject: Nodediffs & db:s

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...


    -==-

* Origin: The Poor Man's Workstation -- Wormerveer NL (2:280/100)
SEEN-BY: 633/267 270
@PATH: 280/100 28/1 10/345 379/1 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.