Problems recovering data volume

jpavan

Hi Allan,
We encounter a problem when retrieving data with datatables editor when the volume of data is important.
This happens with an application and MySql database in GoDaddy, where the message returned by the server is ERR_EMPTY_RESPONSE.
Same application and database on our local servers do not cause problems.
Could you tell us what can cause this error?

allan

You'd need to check the server's error logs. It sounds like there will be a configuration difference between them - perhaps a memory limit.

Allan

jpavan

Hi Allan,
We have extended the "memory_limit" and still we can't find the solution.
We detect that if the json that builds the php used in the ajax of Datatables, weighs up to 1024kb, there are no problems. But when it exceeds 1024kb, the error ERR_EMPTY_RESPONSE appears.
So we have adjusted the values of "post_max_side" and "upload_max_fileside" but this does not solve the problem either.
Did you ever happened? Do you know if there are any other limitations that can be adjusted?
Thanks, as always, for your answers.

allan

It sounds like the max_input_vars option in PHP might be what you want. Is it different between the remote server and the local server?

Allan