多表级联查询分组函数慢问题

 

4张表级联查询的结果分组求和:

select sum(c.quantity) as quantity,sum(c.prefee) as fee
from  Cs_AccountBill a
join Cs_AccountBillDetail b on a.id= b.AccountBillId
join Cs_SettlementDetail c on c.accountBillDetailID = b.id 
join Cs_Settlement d on c.settlementID = d.id

While it's about 21W records of the result,time of select is about 31 ms.

更改如下:

select c.quantity,c.prefee
from  Cs_AccountBill a
join Cs_AccountBillDetail b on a.id= b.AccountBillId
join Cs_SettlementDetail c on c.accountBillDetailID = b.id 
join Cs_Settlement d on c.settlementID = d.id

  

查询时间:40ms左右

 

再将查询的结果map reduce 大概80+ms

BigDecimal sum = list.parallelStream().map(Person::getFee).reduce(BigDecimal::add).get();

//勿用list.stream(),慢

  

  

 

posted @ 2019-04-11 16:42  超轶绝尘  阅读(328)  评论(0编辑  收藏  举报