What type of script do you have working with 800k?
# suitescripte
erictgrubaugh
07/21/2020, 5:28 PMWhat type of script do you have working with 800k?
l
Lincecum
07/21/2020, 5:39 PMI’m thinking we can try map/reduce and adjust concurrency limit for better performance?
a
Akhil Munagala
07/21/2020, 5:53 PMIt is a sales order information, where I have to send those results, back to another system. But, the response time to return these 1000 results is around 1 min because of the search object is having 800k results.
Akhil Munagala
07/21/2020, 5:58 PM@erictgrubaugh do we have any other ways to do this the faster way apart from removing joins?
e
erictgrubaugh
07/21/2020, 6:03 PMThere's no "fast" way to handle 800k records in NS, especially in a real-time script type like a User Event. Generally for massive data sets like this, I recommend moving to a scheduled Map/Reduce script.
a
Akhil Munagala
07/21/2020, 6:08 PMSure, thanks 🙂
s
Sandii
07/21/2020, 6:30 PMKinda surprised you aren't hitting timeout time limit exceeded issues if you arent doing this in a map/reduce already
e
erictgrubaugh
07/21/2020, 6:31 PMYeah and governance limits