I have 100k +/- custom records that need to be individually audited and/or updated on a recurring basis. Running the audit using mass update takes 24hrs +/- Anyone found a way to get better performance when the records need to be audited individually?

For a start, a M/R should allow you to take advantage of 2 processors (or more if you have SuiteCloud+)

hopefully you can use record._*submitFields*_

Wow, thanks for that link. This looks like a really useful document

its the standards netsuite expects from suiteapps

I think I heard of such a document and thought it was only available for SDN partners

Thanks for the help. The sublist trick sounds interesting. It may require the multi processing approach as well.

im not really sure if its really faster. It will use less points

So I spent the day reworking the code to eliminate as much as possible and It looks like I may have cut the runtime in half. It’s still 10x longer than I’d consider acceptable. I also got a quote for the + license to utilize multiple threads but 2k per month is fu$&@# absurd so I’ll bandaid it for now and move it out of NetSuite in the near future. Thanks for the help. Lesson learned:-)

what did your fastest solution look like

I removed the record loading and replaced it with lookupfields, trimmed down searches to bare minimum, split half the logic into another script that can run less frequently, and disabled all other scripts running against the record.