Table copy

[Ruslan Zasukhin]

On 4/13/10 8:22 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,

>> To move records between dbs you should use
>> 
>> A) text export/import
>> B) Sql export/import
>> C) XML export/import
>> 
>> On your choice.
> 
> I tried it now, and its sloooooow....

Which exactly way you did try?
 
Import/export must be very fast.

XML is slowest way.
SQL average 

> Dont you have at least something, which doesn't write the stuff to a file on
> the harddisk first? Maybe using a memory-stream?
> 
> Even my old MS Access 97 could do a
> "INSERT INTO dest_vdb.newtbl SELECT * FROM source_vdb.sourcetbl"
> from one db to another and this is faaaaast...
> 
> I'll put this on mantis.

Yes, we do not have such thing.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]