Fast and lightweight is always ReoGrid development goals, even now has many features supported, there is various technologies to optimize the performance and enhance the user experience.
Everything is fast
Expend worksheet from 100 rows to 100,000 rows just need 8 ms (0.008 second).
Update 100,000 cells data just need one second, that means update one cell only need 0.01 ms, it is very fast.
Why ReoGrid is fast
The following technologies are used to improvement and enhance the performance.
Optimized Memory Management
ReoGrid uses an optimized memory management technology to improvement the cells memory usage. This technology splits a larger spreadsheet into many smaller sheets as tree structure in memory, memory allocation and release is performed on these small paged sheets in order to getting a good balance between time and size of memory use.
Optimized Border Algorithm
Commonly a spreadsheet may contain a lot of cells border that are necessary to be managed in memory and displayed on screen. To make maximum render performance ReoGrid only draw the borders in visible region, there is an algorithm that can make a mapping between the visible region and borders, by using this algorithm, it is possible to find where to start drawing the borders very quickly.
Optimized Viewport Algorithm
ReoGrid uses algorithm to manage and render the visible regions, for implement freeze, worksheet can have multiple viewport to render different content as a part of worksheet, the algorithm provides maximum performance to calculate the rendering region, optimize the text display and anything else displayed on worksheet.