Tag: performance optimization

Problem description The index query system of Bank W is used to calculate and display various aggregate indexes, which is an important support tool of this bank’s operating index system. Since the volume of detailed data is too large, this query system has been adopting a pre-calculation method. However, as the index system advances, this method cannot meet the needs of the rapid growth of index numbers, and gradually becomes a bottleneck restricting the index system. When facing a huge amount of data, the pre-calculation is a method you have to adopt. Bank W has tens of millions of customers,

We have worked out some performance optimization cases before, although there are not many, no one failed. After optimization, the speed is increased several times at least, and dozens of times at most, and even hundreds of times in extreme cases. Speeding up by an order of magnitude has basically become the norm. Here are some cases: Open-source SPL Speeds up Query on Detail Table of Group Insurance by 2000+ Times  Open-source SPL improves bank’s self-service analysis from 5-concurrency to 100-concurrency Open-source SPL speeds up intersection calculation of customer groups in bank user profile by 200+ times Open-source SPL turns