Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The fastest way to move data from one table to another?
Message
From
05/01/2009 02:43:25
Srdjan Djordjevic
Independent
Limassol, Cyprus
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: The fastest way to move data from one table to another?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01370929
Message ID:
01370948
Views:
53
>Hi everybody,
>
>I have two tables with identical structures (Current and History). I need to move all data from Current into History and also clean data a bit during this process. I'm doing this in a scan loop, but the process is very slow (I have more than 4mln. records - 1,6GB). Do you have other ideas of moving data?

[Production] Copy to [free table]
[History] append from [free table]
[Production] clean up the mess

HTH
Sergio
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform