且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

加快通过Select语句循环的SQL更新语句

更新时间:2023-11-09 20:40:28

对SQL查询进行序列化通常会导致性能下降.您可以在一条语句中完成全部操作:

Serializing the SQL queries often leads into bad performance. You can do all in one statement:

$sql = "update ".$billing_table." c ".
       "inner join dids d on d.did=c.telcom_num ".
       "set c.did_id = d.id, c.customer_id = d.customer_id ".
       "where c.customer_id = 0;";