Architecture solution-large list report
How do general report tools or BI systems achieve large list reports?
All the data are read out and the report is presented directly.
The cursor mode is gradually read in and presented.
Read by page using the paging mechanism of the database
Problems with the implementation of traditional patterns:
1) in full read mode, it takes too long to read out, and the user experience is poor; reports calculated in full memory may overflow.
2) Vernier reading mode, which can only turn the page backward.
3) in the paging mode, the initial response is slow and the page turning is slow; data inconsistencies may occur.
The best solution: zero coding, the introduction of streaming computing to achieve the presentation of large list reports!
Large list report
