How is Per Object Storage Usage CalculatedNotification Mail based on Storage Usage in salesforceSalesforce Storage requirementsGetting confused with per-organization allocationData storage limit exceeded?Reasons?and solutions?Developer Edition org now have 256MB data storage?Clarification on Data Storage Model in Sales CloudHow to increase data storage in salesforce developer edition?Truncate object causing storage usage errorHow to get “Storage Usage” organization information of a salesforce to another salesforce org?Automated exports of Current Data Storage Usage data
Why are solar panels kept tilted?
Unexpected Netflix account registered to my Gmail address - any way it could be a hack attempt?
Were any toxic metals used in the International Space Station?
"The van's really booking"
Should generated documentation be stored in a Git repository?
Do we have C++20 ranges library in GCC 9?
How to describe a building set which is like LEGO without using the "LEGO" word?
Extract the characters before last colon
Substring join or additional table, which is faster?
Is this a group? If so, what group is it?
Can a tourist shoot a gun for recreational purpose in the USA?
Given 0s on Assignments with suspected and dismissed cheating?
Holding rent money for my friend which amounts to over $10k?
A case where Bishop for knight isn't a good trade
Why are BJTs common in output stages of power amplifiers?
How to make a not so good looking person more appealing?
Is there an academic word that means "to split hairs over"?
Uh oh, the propeller fell off
Should I communicate in my applications that I'm unemployed out of choice rather than because nobody will have me?
Is there any good reason to write "it is easy to see"?
Help understanding this line - usage of くれる
Is it wrong to omit object pronouns in these sentences?
Can I say: "When was your train leaving?" if the train leaves in the future?
Problem in downloading videos using youtube-dl from unsupported sites
How is Per Object Storage Usage Calculated
Notification Mail based on Storage Usage in salesforceSalesforce Storage requirementsGetting confused with per-organization allocationData storage limit exceeded?Reasons?and solutions?Developer Edition org now have 256MB data storage?Clarification on Data Storage Model in Sales CloudHow to increase data storage in salesforce developer edition?Truncate object causing storage usage errorHow to get “Storage Usage” organization information of a salesforce to another salesforce org?Automated exports of Current Data Storage Usage data
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
In attempting to determine the impact of using Text or LongTextArea types in an object, I was surprised by the values displayed in the Setup > Storage Usage page: the sizes for each object type were equal.
To test each type I created 3 Objects :
- ShortText : an object that contains a single custom field of type Text (255)
- LongTextAreaObject : an object that contains a single field of type LongTextArea(131072)
- LongTextAreaObjectEmpty : an object that is exactly the same as LongTextAreaObject that I am using as a control object where I will only populate the name and nothing else
Using DataLoader the following values were loaded (9999 records for each object type):
- ShortText had a Name field set to 'a' and the custom Text field set to a concatenated value of 255 'a' chars
- LongTextAreaObject had a Name field set to 'a' and the custom LongTextArea field set to a concatenated value of 65470 'a' chars
- LongTextAreaObjectEmpty had a Name field set to 'a' and no values in the custom LongTextArea field
For all 3 objects the Setup > Storage Usage page showed a figure of 19.5MB. 
I would have expected that the ShortText object containing the Text type field would have been smaller due to the amount of data being stored.
Is there an explanation of how the 19.5MB figure is reached? Are Text and LongTextArea some how stored in the same data type under the covers e.g. a CLOB (which would be an odd decision for a 255 length text field)?
data-storage
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
add a comment |
In attempting to determine the impact of using Text or LongTextArea types in an object, I was surprised by the values displayed in the Setup > Storage Usage page: the sizes for each object type were equal.
To test each type I created 3 Objects :
- ShortText : an object that contains a single custom field of type Text (255)
- LongTextAreaObject : an object that contains a single field of type LongTextArea(131072)
- LongTextAreaObjectEmpty : an object that is exactly the same as LongTextAreaObject that I am using as a control object where I will only populate the name and nothing else
Using DataLoader the following values were loaded (9999 records for each object type):
- ShortText had a Name field set to 'a' and the custom Text field set to a concatenated value of 255 'a' chars
- LongTextAreaObject had a Name field set to 'a' and the custom LongTextArea field set to a concatenated value of 65470 'a' chars
- LongTextAreaObjectEmpty had a Name field set to 'a' and no values in the custom LongTextArea field
For all 3 objects the Setup > Storage Usage page showed a figure of 19.5MB.
I would have expected that the ShortText object containing the Text type field would have been smaller due to the amount of data being stored.
Is there an explanation of how the 19.5MB figure is reached? Are Text and LongTextArea some how stored in the same data type under the covers e.g. a CLOB (which would be an odd decision for a 255 length text field)?
data-storage
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
add a comment |
In attempting to determine the impact of using Text or LongTextArea types in an object, I was surprised by the values displayed in the Setup > Storage Usage page: the sizes for each object type were equal.
To test each type I created 3 Objects :
- ShortText : an object that contains a single custom field of type Text (255)
- LongTextAreaObject : an object that contains a single field of type LongTextArea(131072)
- LongTextAreaObjectEmpty : an object that is exactly the same as LongTextAreaObject that I am using as a control object where I will only populate the name and nothing else
Using DataLoader the following values were loaded (9999 records for each object type):
- ShortText had a Name field set to 'a' and the custom Text field set to a concatenated value of 255 'a' chars
- LongTextAreaObject had a Name field set to 'a' and the custom LongTextArea field set to a concatenated value of 65470 'a' chars
- LongTextAreaObjectEmpty had a Name field set to 'a' and no values in the custom LongTextArea field
For all 3 objects the Setup > Storage Usage page showed a figure of 19.5MB.
I would have expected that the ShortText object containing the Text type field would have been smaller due to the amount of data being stored.
Is there an explanation of how the 19.5MB figure is reached? Are Text and LongTextArea some how stored in the same data type under the covers e.g. a CLOB (which would be an odd decision for a 255 length text field)?
data-storage
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
In attempting to determine the impact of using Text or LongTextArea types in an object, I was surprised by the values displayed in the Setup > Storage Usage page: the sizes for each object type were equal.
To test each type I created 3 Objects :
- ShortText : an object that contains a single custom field of type Text (255)
- LongTextAreaObject : an object that contains a single field of type LongTextArea(131072)
- LongTextAreaObjectEmpty : an object that is exactly the same as LongTextAreaObject that I am using as a control object where I will only populate the name and nothing else
Using DataLoader the following values were loaded (9999 records for each object type):
- ShortText had a Name field set to 'a' and the custom Text field set to a concatenated value of 255 'a' chars
- LongTextAreaObject had a Name field set to 'a' and the custom LongTextArea field set to a concatenated value of 65470 'a' chars
- LongTextAreaObjectEmpty had a Name field set to 'a' and no values in the custom LongTextArea field
For all 3 objects the Setup > Storage Usage page showed a figure of 19.5MB.
I would have expected that the ShortText object containing the Text type field would have been smaller due to the amount of data being stored.
Is there an explanation of how the 19.5MB figure is reached? Are Text and LongTextArea some how stored in the same data type under the covers e.g. a CLOB (which would be an odd decision for a 255 length text field)?
data-storage
data-storage
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
asked May 3 at 12:43
Fraser WaterfieldFraser Waterfield
233
233
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Data Storage is not calculated by the number of fields or content in the fields. It calculated as a number of records. Custom Object take 2KB per record. Doesn't matter i if they have 1 field or 200 long text fields populated.
Salesforce uses a simplistic method for calculating storage usage. Most standard and Custom objects are 2KB but some special objects like PersonAccount take 4KB(as its an account and contact)
So in your case. 9999 records take
(9999*2)/1024 = 19.52MB
SRC: https://help.salesforce.com/articleView?id=000193871&type=1
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
add a comment |
What you are seeing in Data Storage is not based on the size of the field for respective object. The storage reflects the size of overall record that is stored in that object. Salesforce record size overview
mentions that any record is roughly around 2KB in size (with some exceptions).
In your case the storage is approximately around 19.5MB based on 9999 records for each object.
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f261017%2fhow-is-per-object-storage-usage-calculated%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Data Storage is not calculated by the number of fields or content in the fields. It calculated as a number of records. Custom Object take 2KB per record. Doesn't matter i if they have 1 field or 200 long text fields populated.
Salesforce uses a simplistic method for calculating storage usage. Most standard and Custom objects are 2KB but some special objects like PersonAccount take 4KB(as its an account and contact)
So in your case. 9999 records take
(9999*2)/1024 = 19.52MB
SRC: https://help.salesforce.com/articleView?id=000193871&type=1
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
add a comment |
Data Storage is not calculated by the number of fields or content in the fields. It calculated as a number of records. Custom Object take 2KB per record. Doesn't matter i if they have 1 field or 200 long text fields populated.
Salesforce uses a simplistic method for calculating storage usage. Most standard and Custom objects are 2KB but some special objects like PersonAccount take 4KB(as its an account and contact)
So in your case. 9999 records take
(9999*2)/1024 = 19.52MB
SRC: https://help.salesforce.com/articleView?id=000193871&type=1
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
add a comment |
Data Storage is not calculated by the number of fields or content in the fields. It calculated as a number of records. Custom Object take 2KB per record. Doesn't matter i if they have 1 field or 200 long text fields populated.
Salesforce uses a simplistic method for calculating storage usage. Most standard and Custom objects are 2KB but some special objects like PersonAccount take 4KB(as its an account and contact)
So in your case. 9999 records take
(9999*2)/1024 = 19.52MB
SRC: https://help.salesforce.com/articleView?id=000193871&type=1
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
Data Storage is not calculated by the number of fields or content in the fields. It calculated as a number of records. Custom Object take 2KB per record. Doesn't matter i if they have 1 field or 200 long text fields populated.
Salesforce uses a simplistic method for calculating storage usage. Most standard and Custom objects are 2KB but some special objects like PersonAccount take 4KB(as its an account and contact)
So in your case. 9999 records take
(9999*2)/1024 = 19.52MB
SRC: https://help.salesforce.com/articleView?id=000193871&type=1
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
answered May 3 at 12:54
Pranay JaiswalPranay Jaiswal
19.3k53263
19.3k53263
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
add a comment |
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
There are also a few that only take 1k - CampaignMember comes to mind - but since you have have a lot of those, that can be helpful if you can use them in place of more 'expensive' objects
– BritishBoyinDC
May 4 at 18:44
add a comment |
What you are seeing in Data Storage is not based on the size of the field for respective object. The storage reflects the size of overall record that is stored in that object. Salesforce record size overview
mentions that any record is roughly around 2KB in size (with some exceptions).
In your case the storage is approximately around 19.5MB based on 9999 records for each object.
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
add a comment |
What you are seeing in Data Storage is not based on the size of the field for respective object. The storage reflects the size of overall record that is stored in that object. Salesforce record size overview
mentions that any record is roughly around 2KB in size (with some exceptions).
In your case the storage is approximately around 19.5MB based on 9999 records for each object.
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
add a comment |
What you are seeing in Data Storage is not based on the size of the field for respective object. The storage reflects the size of overall record that is stored in that object. Salesforce record size overview
mentions that any record is roughly around 2KB in size (with some exceptions).
In your case the storage is approximately around 19.5MB based on 9999 records for each object.
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
What you are seeing in Data Storage is not based on the size of the field for respective object. The storage reflects the size of overall record that is stored in that object. Salesforce record size overview
mentions that any record is roughly around 2KB in size (with some exceptions).
In your case the storage is approximately around 19.5MB based on 9999 records for each object.
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
answered May 3 at 12:56
Jayant DasJayant Das
20.4k21332
20.4k21332
add a comment |
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f261017%2fhow-is-per-object-storage-usage-calculated%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
