Saving 40K+ lines of data ends with 504 Gateway Timeout

[thekrotek]

I use this library to export data from my database. Everything works fine if I try to export not more than 10-15K entries. Ends with 504 error when I export large sets of data (about 30-40K entries).

To fix this I've tried using caching with Redis and splitting main array into chunks each to be saved in a separate file. None helped.

What did help is exporting some table fields, not all of them. For example, if my table has like 20 fields, DB export will return 504 error. If I select only 5-6 fields, everything works pretty fine and surprisingly fast.

Tried to save as XLSX and CSV with the same result.

PHP 8.3.16
PHPSpreadsheet 5.0.0
Ubuntu 22.04.5

[SpikedCola]

Are you accessing your script through a webserver? If so, which one?

It sounds like you might be hitting max_execution_time in PHP.

Try raising this value temporarily to test, or running the script from the CLI (which has no execution time limit).

[thekrotek]

Of course max_execution_time was the first thing to check. It's set to 18K. Problem's definitely NOT with this option. According to my own findings, issue happens when you have lots of entries to save AND lots of fields (cells) per entry. Over 40K entries, 20 fields each in my case.