加快executemany cx_orcale下的更新查询速度

Question

我有大约 50 万行需要在 oracle sql server 的两个表中更新。 我将 0.5 分成 100K 行并尝试执行许多，但它永远持续下去。我有10个文件，每个文件有50万。这将花费我很长时间来更新表格。需要建议来改进或加快流程。

我的代码：

    insert_batch_size=1000
    def UpdateDBWith_Y(Processed_HSMemberFileDf,connection,cursor):
    try:
        Columns = {'ccd_aadhaar_seeding_status':'Y','CCD_LST_MOD_BY':'SYSTEM'}
        Processed_HSMemberFileDf=Processed_HSMemberFileDf.assign(**Columns)
        Processed_HSMemberFileDf.drop('ADHAAR_SEEDING_STATUS', axis=1, inplace=True)
        ListAcctoDB=['ccd_aadhaar_seeding_status','CCD_LST_MOD_BY','PAN']
        Processed_HSMemberFileDf = Processed_HSMemberFileDf[ListAcctoDB]
        bind_update=Processed_HSMemberFileDf.values.tolist()
        print(len(bind_update))
        length=0
        bind_update_chunks = [bind_update[x:x+insert_batch_size] for x in range(0, len(bind_update), insert_batch_size)]
        for insert_chunk in bind_update_chunks:
            start_time = time.time()                  
            _updatequery="update UCIDBA.client_code_dtls set ccd_aadhaar_seeding_status = :1,CCD_LST_MOD_BY=:2,CCD_LST_MOD_DT=SYSDATE where CCD_PAN_NO= :3"
            _updatequery_chld="update UCIDBA.client_code_child_dtls set ccc_aadhaar_seeding_status = :1,CCC_LST_MOD_BY=:2,CCC_LST_MOD_DT=SYSDATE where CCC_PAN_NO= :3"
            logging.info("UpdateDBWith_Y:->Update Query : |" +_updatequery)
            logging.info("UpdateDBWith_Y:->Update Query child: |" +_updatequery_chld)
            cursor.executemany(_updatequery,insert_chunk)
            connection.commit()
            cursor.executemany(_updatequery_chld,insert_chunk)
            connection.commit()
            length=length+len(insert_chunk)
            logging.info("UpdateDBWith_Y:->inserted till : |" +str(length))
            print("--- %s seconds ---" % (time.time() - start_time))
        return True
    except Exception  as e :
        logging.exception("UpdateDBWith_Y:->: |")  
        return False

还有其他方法可以加速或使用executemany吗？