>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?
>
>Thanks in advance.
Insert into ... select ...
would be a fast way but you say there is "clean data" process. Without knowing the details it is like shooting in dark. If it is something you can do with a where clause then you are done with an SQL. I would do the process locally if it is not something like SQL server (with SQL server it would be fast enouhg you wouldn't ask this question I think, but you are using scan...endscan which maybe the reason to be slow).
Cetin