TechnoDoc 9. Handling large reports and performance optimization
June 2026
In the ninth version of TechnoDoc we focused on performance: we optimized the client and server sides and taught the system to confidently handle very large reports containing millions of values.
Client optimization
- It is now possible to work on the client with reports containing up to 8 million parameters. Thanks to the paginated display of large tables, RAM consumption on client workstations stays low.
- Improved the report user interface.
Server optimization
- During report generation, data is streamed to disk instead of RAM, which significantly reduced the application server's memory consumption.
- Added the ability to set the maximum amount of RAM the application server may use.
- Optimized the algorithm for querying data from the historical database: data is loaded in chunks of several hours per parameter and cached in memory for fast value lookup.
Reports and export
- Added a limit on the number of steps in a report with user notification (default — 86,400, the number of seconds in a day) and a separate limit on the number of rows when exporting.
- Added fast report export to Excel without markup.
- Added export of a report to Excel/CSV without creating and viewing it — the fastest way to export data, for example, for a day.
- When exporting to Excel, numbers are stored with the «number» type, and the decimal separator is taken from the operating system's regional settings.
- Added a default time format setting.
These changes make it possible to generate, view and export reports with millions of values while keeping resource consumption minimal.