一次過喺 table 度 delete 成千萬個 row 係好慢既事, 因為佢每一次 delete 就會攪攪個 index, 試過行左成個星期都未行得完。
解決方法就係用 QUICK,
DELETE QUICK FROM table1 WHERE id < 10000000
咁個 database 就會 delete 晒想 delete 既 row 之後先會一次過攪個 index, 幾個鐘就攪掂左。
22nd Jun, 2009
一次過喺 table 度 delete 成千萬個 row 係好慢既事, 因為佢每一次 delete 就會攪攪個 index, 試過行左成個星期都未行得完。
解決方法就係用 QUICK,
DELETE QUICK FROM table1 WHERE id < 10000000
咁個 database 就會 delete 晒想 delete 既 row 之後先會一次過攪個 index, 幾個鐘就攪掂左。