|
Consider using journal. I found it very efficient and, just my opinion, more flexible. 1 - You have an indipendent job doing the sync. 2 - In case of program bugs (you know sometimes...) any action is still possible 3 - Better performance writing the original file Of course you use more disk space, but just temporary. Just my opinion.. Marco --- Tim Truax <truax@xxxxxxxxxxxx> wrote: > Hey all, > I work in a massive 400 shop that moves boo-koo data all > over the place. > I have a process that runs on a host-400 and reads a DDM > file that points to > the remote-400 file. > This process reads the remote-400 file and does minimal > data massaging and > then just writes/updates the record read to a file on the > host-400. > The objective of this process is to take 3.8 million > records from the > remote-400 to the host-400 on a daily basis as quickly as > possible. > Someone wants to apply a trigger on the host-400 > receiving file that will > perform another record addition to another host-400 file > when a record > addition occurs to the initial/original host-400 file. > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.