What is the correct approach to display a huge report in excel in php?

Question

PHP

There are two main huge tables connected 1 by many in postgresql (each table has 2500000 rows). There is a one-to-one relationship between the two tables. It is necessary to take the report from two tables on one excel through PHP. In my approach, php does a SELECT and writes the given data to arrays. Then with the help of PHPEXCEL writes to the template. It takes about half an hour to get 500,000 rows of data. Please advise the correct approach for this example. Thank you!

Answer 1

Write to CSV file.