導入文件或者處理大批量數據時間長,優化方案
DataFormatter formatter = new DataFormatter();
Workbook workbook = new XSSFWorkbook(file.getInputStream());
Sheet sheet = workbook.getSheet("sheet1");
Row dateRow = sheet.getRow(y);
String dataDate = formatter.formatCellValue(dateCell);

可以判斷list 集合是否等于1000,是 插入 后清理list集合,會降低內存消耗,從何達到處理時間縮短

if (tradeListAll.size() > 0 && tradeListAll.size() % 1000 == 0) {
gsDayTradeListService.saveBatch(tradeListAll, 1000);
tradeListAll.clear();
}
if (tradeListAll.size() > 0 && tradeListAll.size() % 1000 != 0) {
gsDayTradeListService.saveBatch(tradeListAll, 1000);
tradeListAll.clear();
}

浙公網安備 33010602011771號