Notifications

249 views

Symptoms


Large delays in system functionality (as the user was running a background script during work hours to update 50,000 records). 

Release


Kingston Patch 6

Cause


It is recommended that when updating large amounts of records, that this be done through a Scheduled Job (and generally in off-business hours). 

Resolution


Per the above, the user's goal of mass updating records can be best accomplished by placing the script they are currently running during the day into a Scheduled Job and having it run in batches each night, in off-business hours.

Doing it this way will allow the user to chip away at the large number of records over a few days, and having the script run by a scheduled job will allow the user to run it during off-hours when no one's day-to-day work will be affected.

Article Information

Last Updated:2018-11-15 01:49:14
Published:2018-08-22