just some ideas :
1. reindexing is not sufficient, rebuild indexes instead (do this after 2. below)
2 .instead of copy to a temp file, sort the file on its primary key to a temp file, it also increases performance
Christian
Christian Desbourse ( Belgium )