coopcycle / coopcycle-web

Logistics & marketplace platform. Only for worker-owned business.
https://coopcycle.org
Other
567 stars 129 forks source link

Export spreadsheets asynchronously #3177

Open alexsegura opened 2 years ago

alexsegura commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

Since 03e689ca610096dd5f23010ead6821463e53c108, the export should be more optimized.

Paul-Eraman-CoopCycle commented 1 week ago

is this still relevant @alexsegura ?