My mapreduce script is stopping with error SSS_TIM...
# suitescript
e
My mapreduce script is stopping with error SSS_TIME_LIMIT_EXCEEDED getInputData, this is probably due to my search has at least 500k records. What is the best way to do in search.load to limit the result to 100K?
e
I cant say if this is the best way, but what I've done in the past was just added a "Date Created" filter to the search, pick a date a while back and just guess/test the date until you get <100,000 results. Then after you run the M/R script once, update the filter to Date created between a date further back and the first date you set, etc etc until you're done
👍 1
e
Add a formula to your search of
rownum < 100000
(
["formulanumeric: rownum","lessthan","100000"]
)
👍 3
☝️ 1
d
I saw a huge time save after switching to running a paginated search (
Search.runPaged(options)
) Check out this thread discussing further performance benefits of using
N/query
for large data sets
👍 1