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
Cable Guy.ax375Cable Guy.ax375 

Delete Massive Data

I'm dealing with a massive data deletion. I have an object called Equipment and it holds 50000 records. I have a java application using SFDC API version 7. It only allows maximum 200 records for each deletion. How should I make it work to delete 50000 records? Is there any quicker way to do this?
 
Thanks,
SuperfellSuperfell
You have to call delete in a loop passing 200 at a time, until you've chunked through the entire set.
Cable Guy.ax375Cable Guy.ax375
Do you have any sample code for deleting 200 records each time?
 
Or since I will need to delete all the records in that table, can I drop the object and re-create the object? Any sample code for this will be very helpful.
 
Thanks,
Rick.BanisterRick.Banister
We can give you a 30-day free trial of Relational Junction, which can do this very easily with any amount of data. Write me directly at the email address below.