The following mostly applies only for ISAM, MyISAM, and HEAP tables. If you only use transaction-safe tables (BDB tables) in an a update, you can do COMMIT and ROLLBACK also with MySQL. The problem ...

是这样，我要从其他地方读取50万条数据插入到PG数据库。请问我在循环里，是每个SQL执行后，进行一次commit ，还是所有SQL执行完成后，在commit。