Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Jing Liu wrote:
>
> Thomas Parsli wrote:
>
> > "Art S. Kagel" <kagel@bloomberg.net> writes:
> >
> > > Thomas Parsli wrote:
> > > >
> > > > How fast should dbcopy be? :D
> > >
> > > Ideally about 3X the speed of INSERT INTO...SELECT FROM... going from 7.xx
> > > to 7.xx with the dbcopy running on either the source or target machine (it
> > > can run on a third machine, see below).
> > >
> > > Unfortunately 5.xx does not support Fetch Array or the large
> > > communications buffers needed for the -F option to work to best advantage
> > > so the speed will be only slightly faster than using dbaccess to do the
> > > copy.
> >
> > We're trying the unload->rcopy->load path, this seems faster on the
> > relativly small tests I've done. I suppose gzip could help with our 10Mb WAN...
>
> Is there any way to do unload and load automatically to copy multipile tables? I think it
> is not suported in routines.
[SNIP]
That is what dbexport/dbimport do.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.