[SalesForce] Heap size limit when uploading file using Visualforce page

I have a visualforce page which has control.
I am using this to upload a text file. I have property of type
Attachment in my controller. Value of inpufile control will be
Body of Attachment property.

In my controller action method, I am reading file contents as –

string attachmentBodyString = attachmentProperty.Body.toString();

I need to parse this string to do some business logic.
For larger files, I am running into Heap size limit error.

text file is around 1.5MB in size with around 15K lines.

I tried doing optimization wherever I can but still running into issues.

Can someone suggest any workaround for this ?

Best Answer

finally i optimized the code wherever i can. Got rid of temporary string variables and was able to make the code work for file size of 1.5 MB. It is now optimized to the point where it should be able to handle upto 3 to 4 MB file.

Related Solutions

[SalesForce] Heap Size Limit in Salesforce

If you are trying to load the data synchronously, then it will hit this limit of 6MB. I'd recommend you call asynchronously, which is nothing but using VisualForce Remoting functions.

Can you paste your code so that I'll point out a better way to go about it.

Thanks Akash

[SalesForce] Heap size limit in Javascript Remoting method

Yes, it's bytes, and yes, synchronous calls are limited to 6MB.

To reduce total heap usage, use a query-more loop:

Integer skipRows = 10000;
Account[] results = new Account[0];
for(Account record:[SELECT Id, Name FROM Account LIMIT 12000]) {
    if(skipRows-- < 0) {
        results.add(record);
    }
}

This "query-more" loop uses only as much heap as necessary for 200 results plus the size of the result list.

Best Answer

Related Solutions

[SalesForce] Heap Size Limit in Salesforce

[SalesForce] Heap size limit in Javascript Remoting method

Related Topic