I have a request to touch a million records a mont...
# suitescript
c
I have a request to touch a million records a month for some analysis. It's a "month end" sort of thing. The account has max concurrency of 2. Is this sort of request even possible?
j

https://www.youtube.com/watch?v=jpmiZ7zsHXY

1000 2
🤣 4
c
I watched that on VH1 when it came out, lol
n
Depends on how quickly they want it completed. But i mean yeah its possible, its just going to be slow
c
The current imagination formation is overnight.
n
ehhhhhh probably no
If they are custom records with no other scripts running on them, and you don't have any other processes that the Map/Reduce would have to yield to, and you optimized your code to run as efficiently as possible
probably still no
s
overnight with that concurrency is laughable. Plan for a weekend probably.
Without knowing more context, maybe run your change on 100 records and time it, then use that to estimate the number of hours.
c
What is the value you are trying to modify? Is it something you can source or move a custom record (and source those fields) and have all records point to that single record and update just the single record?