Several calculations within the Report Controller are done by PHP after loading all the records. This can be very time consuming and even deplete available memory. Creating a SQL statement using SUM(), etc.. would push the calculation into MySQL and be better for large databases.
Several calculations within the Report Controller are done by PHP after loading all the records. This can be very time consuming and even deplete available memory. Creating a SQL statement using SUM(), etc.. would push the calculation into MySQL and be better for large databases.