减少与数据库交互次数 day96-性能压测-优化-优化三级分类数据获取 _吞吐量

有时候，通过合理的业务代码的设计，避免频繁的数据库的交互，也能很大程度提升吞吐量
这里是我们之前吞吐量测试的表，可以看到三级分类数据获取的吞吐量慢的一批
【减少与数据库交互次数day96-性能压测-优化-优化三级分类数据获取】这是之前的代码，仔细看可以看到每次获取子分类都是从数据库获取，不断的与数据库交互，而且父分类数据量越大交互次数越多，现在看显然及其不合理
@Overridepublic Map> getCatalogJson() {List category1EntityList = findCatelog1s();Map> catelog2Vos = category1EntityList.stream().collect(Collectors.toMap(k -> k.getCatId().toString(), v -> {//1.查到一级分类的所有二级分类List category2EntityList = this.list(new QueryWrapper().eq("parent_cid", v.getCatId()));//2.获取二级分类vo集合List catelog2VoList = category2EntityList.stream().map(catelog2 -> {List category3EntityList = this.list(new QueryWrapper().eq("parent_cid", catelog2.getCatId()));//3.获取三级分类vo集合List catelog3Vos = null;if(category3EntityList !=null && category3EntityList.size() > 0){catelog3Vos = category3EntityList.stream().map(catelog3 -> {//获取三级分类voCatelog2Vo.Catelog3Vo catelog3Vo = new Catelog2Vo.Catelog3Vo(catelog3.getParentCid().toString(), catelog3.getCatId().toString(), catelog3.getName());return catelog3Vo;}).collect(Collectors.toList());}//2.获取二级分类voCatelog2Vo catelog2Vo = new Catelog2Vo(v.getCatId().toString(), catelog3Vos, catelog2.getCatId().toString(), catelog2.getName());return catelog2Vo;}).collect(Collectors.toList());return catelog2VoList;}));return catelog2Vos;}

文章插图
动手
思路：先一次性查询出所有分类数据，然后每次再从里面获取对应子分类，改造后代码如下

@Overridepublic Map> getCatalogJson() {List categoryEntities = this.list(null);List category1EntityList = getParent_cid(categoryEntities,0l);Map> catelog2Vos = category1EntityList.stream().collect(Collectors.toMap(k -> k.getCatId().toString(), v -> {//1.查到一级分类的所有二级分类List category2EntityList = getParent_cid(categoryEntities,v.getCatId());//2.获取二级分类vo集合List catelog2VoList = category2EntityList.stream().map(catelog2 -> {List category3EntityList = getParent_cid(categoryEntities,catelog2.getCatId());//3.获取三级分类vo集合List catelog3Vos = null;if(category3EntityList !=null && category3EntityList.size() > 0){catelog3Vos = category3EntityList.stream().map(catelog3 -> {//获取三级分类voCatelog2Vo.Catelog3Vo catelog3Vo = new Catelog2Vo.Catelog3Vo(catelog3.getParentCid().toString(), catelog3.getCatId().toString(), catelog3.getName());return catelog3Vo;}).collect(Collectors.toList());}//2.获取二级分类voCatelog2Vo catelog2Vo = new Catelog2Vo(v.getCatId().toString(), catelog3Vos, catelog2.getCatId().toString(), catelog2.getName());return catelog2Vo;}).collect(Collectors.toList());return catelog2VoList;}));return catelog2Vos;}private List getParent_cid( List categoryEntities,Long parent_cid) {List collect = categoryEntities.stream().filter(categoryEntity -> categoryEntity.getParentCid() == parent_cid).collect(Collectors.toList());return collect;}

再次进行压测
查看聚合报告发现吞吐量比之前多了几十倍，虽然还是不太高
填表