Hi
Yes, it's not a Dédalo issue; it's an installation configuration problem, usually an Apache timeout and the keepalive directives and PHP set_time_limit and max_execution_time
Two scenarios:
1 work server.
In certain situations, when exporting a large list of data, thousands of rows, and multiple columns, PHP may take some time to process the request. If the Apache server has a sort timeout, it will terminate the connection with the client and PHP, preventing Apache from waiting for PHP to complete its task. Therefore, it is recommended to set a long timeout for both Apache and PHP on the work server, ideally 3600 seconds (1 hour) or more, depending on the characteristics of your server. The specific timeout duration depends on the amount of data to be processed and the time PHP requires to process the request. (Note: In slower servers, PHP may require more time to process the request compared to faster servers.)
2 the public/web server
In the public/web server with MariaDB and Dédalo Public API, the situation is different. In this case, the timeout must be set to close the connections as quickly as possible because a long timeout could be problematic with multiple connections and requests. Since this scenario provides a fast way to access the data (because the data is resolved), the Apache timeout could be set to 30 or 60 seconds (60 seconds is the default configuration).
Setting Apache timeout needs to be set according to the server and the amount data to be processed.
Final note: Take in account that if your server is behind a proxy, the proxy has to maintain the connection between client and server.
Best
