>>I was doing this, but the process didn't finish in more than 2h.
>
>I think
>
>(1) select * from Current into cursor tmp readwrite
>(2) Manipulate tmp
>(3) insert into History select * from tmp
How much memory would we need to hold 1.6MGB cursor?
BTW, the process I ran on the Network didn't finish running the whole night, so I simply interrupted it this morning.
I like Al's suggestions, but I'm not exactly sure how to append by chunks (10% of the file for each iteration). I will definitely try to do this next time locally and using exclusive access.
If it's not broken, fix it until it is.
My Blog