Table copy

[Ruslan Zasukhin]

On 14/4/10 12:43 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

>> Import/export must be very fast.
> 
> this cant be fast, because it writes the whole content of the table in a file
> on the harddisk.
> Or did I miss something ;-) ?

Well, in worse case this will take double time comparing to

    READ db 1   ->   INSERT db2
    disk             disk


But I think it will take not so much additionally.
Because 
    READ from DB, and WRITE TO DB  are more complex tasks
    than read/write plain text

It needs to bench it

-- 
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]