OpenEuphoria

RE: EDS cry out!!!! Rob, Andy Sepa, anyone]

• Posted by jordah ferguson <jorfergie03 at yahoo.com> Mar 27, 2002
• 392 views

Rob,
what did you mean? Do you mean that instead of copying the data in the 
record i could simply copy the record key to another table and it would 
work fine.

for example, if i my db_record_key was jordah in a table called 
jordah_table. do you mean i could simply copy this jordah to another 
table called robert without the need for transfering the key data?

if so, then this should be added to the documentation? or have i not 
read it right?

Good day. Rob

Robert Craig wrote:
> 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
> 
>