J
jsniemi79
Guest
I have a csv file that has roughly 320,000 records with 9 fields on each record. I have a batch process setup to pull this file from a remote ftp server and perform an update/create nightly. Upon creation or update of the record, 3 triggers are executed. 2 to attach related records and one to update a field on the object in Rollbase. I kicked off the process manually and it too almost 26 hours to complete the process. Obviously, that will make it difficult to update daily. We've had other import processes that didn't take nearly that long to complete. Is there anything I can do to make this process speed up? I have screen shots of what I am seeing in the document below. (Please visit the site to view this file)
Continue reading...
Continue reading...