What makes a Salesforce inspector faster than a workbench and data loader?
I have a use case where I need to delete a few million duplicates from my org. I have explored the following 3 tools to achieve this. Salesforce Inspector, Data Loader and Workbench. The performance of the Salesforce inspector is exponentially faster than the other two. Assuming that all of them use the bulk APIs for mass delete, why would the performance of one be so different and better than the other two? Can someone help me understand?
Through Salesforce inspector, you can run a simple SOQL query, copy to Excel, and manipulate as needed. From there, you could copy from Excel back into the extension and paste. Error handling was a breeze, and it also handled asynchronous calls with ease. The best features of Salesforce Inspector are that it’s both free and well-maintained by the community.
Where It Shines -
- Mass inserting/updating records
- Capturing API names for fields
- Reference object relationships on-the-fly