I have a script that create 1500 records. The records are pretty simple, 5 fields. As you know it take a while to create the 1500 records. Is there's a way to create the 1500 records quickly ? I'm asking that because in Oracle, MySQL, SQL Server, create 1500 records takes no time.

Turn it into a map/reduce & change the concurrency limit on the deployment. The more suitecloud+ licenses you have, the faster it will go. You can do the same by multi-threading CSV imports

Good point My customer has concurrency max of 2 😞

you can use the task module and create a CSV import for them... That's generally faster I think.

CSV imports using N/task only use a single thread, so that's not actually correct

CSV imports aren't equivalent to suitescript though, its faster

if you have a parent record, you can create children in a sublist operation, and it’s exceedingly fast

Thanks

2 is default. 5 is a single SuiteCloud Plus license

ah ok

+1 for the parent record sublist editing. It's a bit more complicated of a pattern, but much faster. Only really suitable for custom records IMO. We limited each "container" (parent record) to have 500 child records; but I think that's because we fine tuned it for process time and governance (using M/R)

correct; my assumption was this is a custom record? perhaps i’m incorrect. also, this approach can handle well above 500 records, but I don’t recall off-hand how many thousands

Thanks a lot. I will try it