【数据库】Django ORM 并发存入,万级写入


    """
        PS:底层应该也是使用了ORM的事务所性质,读取10000行后一并写入
    """
    start = time.time()
    test = []
    try:
        for i in range(0, 180000):
            test.append(models.HistoryOrder(game_uuid=game_uuid, order_uuid=order_uuid,user_id=1,
                                            issue=issue, user_code="测试", money=1,order_res=0,
                                            pay_time=pay_time, action_time=datetime.datetime.now()))
            if len(test) >= 10000:
                models.HistoryOrder.objects.bulk_create(test)
                test = []
        models.HistoryOrder.objects.bulk_create(test)
    except:
        print(traceback.format_exc())
    print("写入耗时", time.time() - start)
    print("处理订单数", models.HistoryOrder.objects.all().count())