Export Big Data to Excel

I have some project with big data.

I have problem when I export it to excel and showing it to the screen, Is there any way to speed up the process ?

If i am not mistaken by MAKING THE MEMORY consumption bigger …Can anybody help?
Thank you

https://www.php.net/manual/en/ini.core.php#ini.memory-limit
https://www.php.net/manual/en/info.configuration.php#ini.max-execution-time

Trying to export about 3000 rows to excel or csv and it just hags. i get the popup with export and that is it.
any ideas?

thanks

  1. Since you export 3000 rows, you probably do not have enough memory or execution time. You better check your php.ini, arbei wrote:

https://www.php.net/manual/en/ini.core.php#ini.memory-limit
https://www.php.net/manual/en/info.configuration.php#ini.max-execution-time

  1. You may also enable PHP “log_errors” and specify “error-log” (error log file) and check the error logged by PHP, see:
    https://www.php.net/manual/en/errorfunc.configuration.php#ini.log-errors
    https://www.php.net/manual/en/errorfunc.configuration.php#ini.error-log
    Then turn on Tools → Debug, generate the ewcfg.php again and run the script again.