导入文件或者处理大批量数据时间长，优化方案

 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();

}