0

If I define a Custom Field (TASK, CASE, ACTIVITY) that is either Large Text or Rich Text field and set the size to 32.000 (MAX size possible), would it be compressed on disk when not used?

For example, if I use 1.000 characters of a 32.000 Rich Text field, would my storage count 32.000 or 1.000?

Thanks

Improve this question

1 Answer 1

Reset to default
8

Neither, actually.

SObject records are, for the most part, counted as a flat 2 kB towards your "data storage" space allocation (not to be confused with "file storage" which covers things like the ContentDocument). This is true no matter how many fields (of any type, including LongTextArea) your SObject has and no matter how many of those fields your individual record has filled with data.

The exceptions are noted on this help page (and even then, most of the exceptions are still 2 kB)

Source: My org has LongTextArea field(s) on Case, Opportunity, and more.
~900k Cases => 1.7 GB of data storage space used
~210k Opportunities => 421 MB of data storage space used

In most orgs, I think that the obvious standout is going to be EmailMessage, where each record is 2 kB + every byte in the TextBody and HtmlBody fields.

Also, as mentioned by Phil W in the comments, images in rich text fields (which are different from long text area fields) contribute to the "file storage" limit (saved to ContentReference, according to this answer by sfdcfox)

Improve this answer
2
  • 4
    Worth explicitly pointing out images in rich text are in file storage, not inline within the rich text.
    – Phil W
    Commented Apr 3, 2023 at 20:02
  • 1
    @PhilW it is done
    – Derek F
    Commented Apr 3, 2023 at 21:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .