Re: how to copy large data fast

On 15/01/07, Ian Michael Gumby <im_gumby@hotmail.com> wrote: > > > > >From: "John" <jgleipold@gmail.com> > > >roger@star2000.com.tw wrote: > > > Dear all: > > > I intend to copy large data from ids7.3 to ids10 . > > > The data size about 40 GB includes several hundred tables. > > > I try my best to copy it fast as I can such that > > > - use INSERT .. SELECT command to copy data > > > - create index after copy data > > > - separate into several process running concurrently. > > > - set database unlogged. > > > Is any other way that I can make it faster ? > > > Or any parameters I can modify to make it ? > > > >HPL? (High performance loader) > > > > He has the data with a table. > > So he can do a select from the local database and insert in to the remote > database, assuming that he can establish a connection to that machine... > > > This would be faster that the HPL since he's skipping the unload process. > > He could do each table in parallel as well. > > That would be the *fastest* way. > > Well, actually there is a "faster" way, but it would require a tad more > work, however it isn't worth the effort. > > > -G > > _________________________________________________________________ > Dave vs. Carl: The Insignificant Championship Series. Who will win? > http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://davevscarl.spaces.live.com/?icid=T001MSN38C07001 > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Need to watch logging, both databases need to be the same so there may be a requirement for lots of log space on the target to avoid long tx, also the number of locks used may come into play if the tables have a large number of records. However that aside I agree this is the fastest method. Keith