Performance optimization of summary table of any combination of multi-layer subjects

Posted Jun 5, 20202 min read

Summary

In the actual report development process, when we encounter problems, we often cannot think of the optimal solution at the beginning. We can try to implement it in the simplest and easiest way first, and then optimize it step by step; compare the defects of each solution and the performance improvement brought by the improvement, so as to finally meet the business needs. In this article, we have adopted this method. The steps of gradual optimization are as follows:1. Multiple traversal schemes; 2. One-time traversal schemes; 3. Pre-summary schemes, query part is optimized on the basis of 2; Program. Of course, good ideas also need good tools to cooperate and be able to achieve it, esProc is this weapon. Go to Qiangan College to see what happens Performance optimization of summary table of any combination of multi-layer subjects

Video address: http://player.youku.com/embed...

[[Download Attachment]Performance Optimization of Multi-layer Subject Combination Table][ http://img.raqsoft.com .cn/uploads/1024/15718789820009e74.pdf)