I have 100s of Counties and 6,00,000 Customers which belong to one of these Counties in my NetSuite Account. There are a few assignments in County record that need to be updated to the Customers. I have written a user event script which will trigger when a county has been updated. The user event script in turn will trigger a map/reduce script to update these assignment to all the customers that belong to the County. I have used the Map/Reduce script to update Customer records since some of the Counties have 1000s of customers and the user event script governance limit is less. Also I want to store the field values for all the customers since they are useful for reporting.
The problem I face now is the unavailabillity of map/reduce script deployments at times. Since there are 100s of counties and all of them may get concurrently updated using csv import, there are not enough active map/reduce script deployments at times. It is not practical to create as much map/reduce script deployments as the number of counties in the account.
Please help me with an expert advice to address this problem or an alternate solution to get the assignments updated in the Customer records as soon as the Counties are updated. Finding a solution for this issue is very critical for me. Thanks in advance.!!