March 13, 200619 yr Hi all, I have a looping script that inserts files (physical files, not refs) into a container. Before the script finishes the insertion of its 3990 files it crashes. I'm thinking that this must have something to do with the File Cache size and/or Saving Cache Contents, which can be specified in Preferences. Can anyone offer some insight as to how I can remedy this? FYI Script exits loop properly, so I know that isn't the problem. Also, toward the end of each loop is a "Commit Record" step. I thought that step would remedy it, but it didn't. Thanks in advance for any help offered!
March 13, 200619 yr Author Hi Vaughan, Thanks for the suggestion! Would you suggest I do that after every X number of records? I don't want to do this for every record, do I?
March 14, 200619 yr Flush Cache will probably be a significant performance hit: I'd expect it to take a couple of seconds to perform. So run it every 1,000 records or so. Heck, you could try getting it to flush just at record 3989 and see if it makes a difference. :
March 14, 200619 yr Author Thanks, Vaughan! I'd already set it to flush cache every 300 records and that got me through the script just fine. This is a one-time script that will never run again, so performance wasn't a big concern. Thanks again, you were a big help!
Create an account or sign in to comment