I was facing a typical issue in production related to displaying large amount of data on web page.
The web page contains history information of a loan (The data is huge). On developer machine it was able to display the complete data but when the change was deployed to server it was showing http 500 error. The error was something like “Response Buffer Limit Exceeded. Execution of the ASP page caused the Response Buffer to exceed its configured limit.”
- Add Response.buffer = true on the top of your page.
- Edit AspBufferingLimit limit in the metabase.xml file. By default the value is around 4194304 (bytes, i.e. 4Mb). Increase the limit to higher values based on the amount of data to display.
- The IIS restart is not required for the metabase.xml editing, but to make the Metabase.xml file write-able, you need to go to the IIS control panel, right click the server, select properties, and check off the box that says “allow changes to MetaBase configuration while IIS is running".