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
Mounika Karri 6Mounika Karri 6 

How to insert 60 million records at once?

Raj VakatiRaj Vakati
You can load them by using data loader batch job and set the batch job to 200 

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_intro.htm
https://trailhead.salesforce.com/en/content/learn/modules/api_basics/api_basics_bulk
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_jobs_intro.htm
Deepali KulshresthaDeepali Kulshrestha
Hi Mounika,

Salesforce has come up with a new concept - BIG OBJECT

As the name suggests it can hold billions of records. Although, it has some limitations. You can not work with it like a Custom object.

Please check Salesforce documentation for more info: https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/

You can also check trailhead on big object: https://trailhead.salesforce.com/modules/big_objects

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha

 
Mounika Karri 6Mounika Karri 6
Hi Deepali,
Thankyou for the information. It was helpful but does Big Object allow DML Operation? 
I dint understand how to insert the records. Dont mind my question I am little new to salesforce.
Raj VakatiRaj Vakati
You can do a DML on big objects and you need to use database.insertImmediate
https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/big_object_populate_apex.htm 
// Define the record.
PhoneBook__b pb = new PhoneBook__b();
pb.FirstName__c = 'John';
pb.LastName__c = 'Smith';
pb.Address__c = '1 Market St';
pb.PhoneNumber__c = '555-1212';
database.insertImmediate(pb);
// A single record will be created in the big object.

 
Deepali KulshresthaDeepali Kulshrestha
Hi Mounika,

Only some standard objects don’t support DML operations although you can still obtain them in queries.

Here is the link of sObjects That Don’t Support DML Operations

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dml_non_dml_objects.htm 

For Inserting and Updating records you can go through with this link ,it will help you to understand how to insert new record.

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_dml_examples_insert_update.htm

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha