Table APi behaves differently with increase sys_param limit

[rdill]

when retrieving data with table API with less sys_param limit it is giving valid json(returning result array json)  and working as expected, However when increase the sys_param limit it is returning invalid json(Meaning along with the result array it is giving empty string)..This is impacting our integration as unable to parse invalid json

Note: the sys_param limit is different for different table that gives this behaviour

why the API is behaving like this??

 is it a bug ?

is there any way to resolve this as less sys_param value is impacting the performance??

[Maik Skoddow]

Check the response size. It is 5 MB. By default, the system limits the size of REST responses that are not saved as attachments to 5 MB. Direct REST responses that exceed this limit generate an error. To support larger response sizes, either save the response as an attachment or increase the response size limit with the glide.pf.rest.response_payload_max_size system property. This system property supports a maximum value of 10 MB.

[rdill]

Can u please give me reference for both the options How and where i can set this property glide.pf.rest.response_payload_max_size and How and where to save the response as attachment.