Re: EDS cry out!!!! Rob, Andy Sepa, anyone]
Jordah Ferguson writes:
> I have a problem, i want to perform copy and move
> operations of records between database tables.
> 1) To perform a copy of contents of data from one table to another, i do
>
> a for loop, to get each key and its
> data then insert it in the destination table.
>
> 2) To perform a move operation, i do exactly the same as above followed
> by deleting the original record from the first table. Right?
Sounds reasonable.
> The above operations would work fine for me if one record
> was being moved or saved, but moving 20 to 30 records
> records which inturn have over 30kb of data can tend to be very sloww!!!
> is there a better and faster way of copying and moving data
> between tables?
No.
I suppose in the future it would be possible for EDS to have a
move operation that would not actually copy the data,
but would simply copy the pointers to the key and data portion,
creating a new record in another table.
Of course, you could do something similar today by not
copying the 30K data, but just copying the key value into a record
in the other table. The key can be used to quickly locate and retrieve
a record.
Regards,
Rob Craig
Rapid Deployment Software
http://www.RapidEuphoria.com
|
Not Categorized, Please Help
|
|
