Re: Slow dbcopy?

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