SQL Tuning for massive data update.

update table with
order by table1.rowid;
It can save a lot of I/O read time!

Detail about rowid
http://ningoo.itpub.net/post/2149/226286