One accounting and reporting system supported by our company began to grow very quickly in the amount of data stored. The system is written in PHP using the Yii2 framework. Initially, the reports were built through the library PhpSpreadsheet, which replaced the already long deprecated, PhpExcel.
Among the different types of reporting was one very large - in fact the complete set of all data stored in the database should be uploaded into one excel table. At the initial stage, there were no problems, but when the volume began to exceed many hundreds of thousands of records, the ...[/h]