Apex Code Development You need to sign in to do that
Don't have an account?
Record data usage is very large for simple custom object
Hi,
We have a very simpel standard object.
We have a very simpel standard object.
- An autonumber for the name
- A textfield for a unique string (length 18)
- A phone number field
- A date field
Plus ofcourse the standard created by etc...
No track activities or track field history, only reports and search and the sharing and API access enabled
Now we are populating this object with data from an outside source, we want to import about 1,5 milion records. This is about 60MB of data on our external database.
But when imported only a third we were already at 1Gig of storage space in Salesforce, that would mean that all 1,5 million lines would be arround 3Gig of data. I understand that some meta data is stored, but going from 60MB to 3Gig to store a few fields of data?
Are we doing something wrong? Why is SF using this amount of storage for this simple request?
I would suggest you to refer to this knowledge article on how much storage space a record of a particalr object might take place-
https://help.salesforce.com/s/articleView?id=000318951&type=1.
I am assuming your are using the Contact object to store your data . so my calculations are as follows-
1. contact record takes around 2 kiloByte
2. 2KB * 1,500,000 = 3,000,000 KB = 3000 MB or 2GB.
Salesforce consumes same amount of storage space regardless of whether some fields are populated or asll are populated, I would guess this is to do something how salesforce stores records in database and allocates space to it.
All Answers
I would suggest you to refer to this knowledge article on how much storage space a record of a particalr object might take place-
https://help.salesforce.com/s/articleView?id=000318951&type=1.
I am assuming your are using the Contact object to store your data . so my calculations are as follows-
1. contact record takes around 2 kiloByte
2. 2KB * 1,500,000 = 3,000,000 KB = 3000 MB or 2GB.
Salesforce consumes same amount of storage space regardless of whether some fields are populated or asll are populated, I would guess this is to do something how salesforce stores records in database and allocates space to it.