coopcycle-web icon indicating copy to clipboard operation
coopcycle-web copied to clipboard

Export spreadsheets asynchronously

Open alexsegura opened this issue 2 years ago • 3 comments

When exporting deliveries on a large range of dates, we are getting 504 timeout errors.

To fix this, the deliveries export needs to be done asynchronously, like when exporting tasks.

alexsegura avatar Mar 21 '22 10:03 alexsegura

As an intermediary solution, we could also implement this export using pure SQL, it seems possible with one big query. Because what seems to cause timeouts is the time spent in PHP building objects, not executing SQL.

Capture d’écran 2022-04-05 à 12 54 37

alexsegura avatar Apr 05 '22 11:04 alexsegura

Since 03e689ca610096dd5f23010ead6821463e53c108, the export should be more optimized.

alexsegura avatar Apr 07 '22 07:04 alexsegura