function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Angello Camacho DragoAngello Camacho Drago 

Visualforce page Error Response size exceeded 15MB organization limit

I am exporting opportunity data to an excel file xls, but when the query has many data I get this error "Response size exceeded 15MB organization limit", I only use a HTML table, an apex:ouputtext to change the date format and two apex:repeat for the rows, I want to show more than 30,000 records, can some one help me?.

Thanks.
bob_buzzardbob_buzzard
There's no way around the maximum page size returned - it's a hard limit and must be below 15Mb.

You'll need to use multiple requests to export the data - i.e. initially extract and render the first 20-30k records, then repeatedly execute JavaScript to bring the next 'n' records and append to the table. I reckon you'll start seeing some performance impact on the browser itself as the raw amount of information it has to manage increases.
Angello Camacho DragoAngello Camacho Drago
Hi Bob, thank you for the reply, do you have any example code?

Thanks.