We are migrating from Syteline to NetSuite. I erroneously imported 60,000 BOM Component records into our Sandbox. We created a saved search to identify the item records to delete, and our in-house NetSuite person used a bulk delete utility to remove them, but it took 8 hours. Is there a faster programmatic way to bulk delete records using SuiteQL or the REST API, or something else?

What type of Suitescript was used to do the delete?

I don't know what his "bulk delete" script was, he told me he got it from NetSuite support. I can ask him today.

A map/reduce script that deletes 60k records will take 6+ hours even if there are no UE scripts deployed on the record type (from personal experience).

Thanks guys - I guess some things take time. I will avoid making the same mistake again :)

Maybe he means a Mass Update script, that can be a simple record.delete()...

no. sandbox is slow. there is a productivity lift that occurs when on a production account bc production accounts are on faster servers. sandbox accounts performance is slow by nature and that’s just how it works

Thanks all

both points are accurate, ime - a Mass update record.delete in sandbox is going to be way slower than an MR with high concurrency in sandbox