PSA: don't forget about running a paginated search...
# suitescript
d
PSA: don't forget about running a paginated search There was a script written using
ResultSet.each()
for the first 4000 results and
ResultSet.getRange(…)
thereafter, which was hitting
SSS_USAGE_LIMIT_EXCEEDED
after 3 minutes. Changed it into a paginated search, and it completed in 12 seconds
👌 1
just over 100k results Checked SuiteScript 2.x API Governance. It makes sense why it ran out of units:
PagedData.fetch(options)
5 units (max 1000 results per page)
ResultSet.each(callback)
10 units (limited first 4000 results)
ResultSet.getRange(options)
10 units (max 1000 results)
Doesn't explain the speed difference though...