数据库大批量操作数据耗时分析

qfQbsCellDao.callBatchTasks(new Callable<Object>() {
            @Override
            public Object call() throws Exception {
                for (DataAdjustmentSyncCellQBSInfos cellItem : cellQBSInfos) {

                    TblQFQbsCell cellData = new TblQFQbsCell();
                    cellData.setCellId(cellItem.getId());
                    cellData.setCellCode(cellItem.getCode());
                    cellData.setCellName(cellItem.getName());
                    cellData.setCellTypeId(cellItem.getCellTypeId());
                    cellData.setPartId(cellItem.getPartQBSId());
                    cellData.setContractId(cellItem.getContractId());
                    cellData.setModifyTime(cellItem.getLastModTime());
                    cellData.setState(cellItem.getState());
                    cellData.setJsonData(gson.toJson(cellItem));

                    qfQbsCellDao
                            .createOrUpdate(cellData);
                }
                return null;
            }
        })

for (DataAdjustmentSyncCellQBSInfos cellItem : cellQBSInfos) {

            TblQFQbsCell cellData = new TblQFQbsCell();
            cellData.setCellId(cellItem.getId());
            cellData.setCellCode(cellItem.getCode());
            cellData.setCellName(cellItem.getName());
            cellData.setCellTypeId(cellItem.getCellTypeId());
            cellData.setPartId(cellItem.getPartQBSId());
            cellData.setContractId(cellItem.getContractId());
            cellData.setModifyTime(cellItem.getLastModTime());
            cellData.setState(cellItem.getState());
            cellData.setJsonData(gson.toJson(cellItem));

            qfQbsCellDao
                    .createOrUpdate(cellData);
        }

// ORMLite的数据连接封装类
        AndroidDatabaseConnection adc = new AndroidDatabaseConnection(baseDBHelper.getWritableDatabase(),true);
        qfQbsCellDao.setAutoCommit(adc,false);
        // 存储点名称为create_claxx
        Savepoint sp = adc.setSavePoint("Create_Update_Cell");
        for (DataAdjustmentSyncCellQBSInfos cellItem : cellQBSInfos) {

            TblQFQbsCell cellData = new TblQFQbsCell();
            cellData.setCellId(cellItem.getId());
            cellData.setCellCode(cellItem.getCode());
            cellData.setCellName(cellItem.getName());
            cellData.setCellTypeId(cellItem.getCellTypeId());
            cellData.setPartId(cellItem.getPartQBSId());
            cellData.setContractId(cellItem.getContractId());
            cellData.setModifyTime(cellItem.getLastModTime());
            cellData.setState(cellItem.getState());
            cellData.setJsonData(gson.toJson(cellItem));

            qfQbsCellDao
                    .createOrUpdate(cellData);
        }
        adc.commit(sp);