Kent Searight Posted March 13, 2006 Posted March 13, 2006 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!
Vaughan Posted March 13, 2006 Posted March 13, 2006 Try putting a "flush cache to disk" step in there somewhere.
Kent Searight Posted March 13, 2006 Author Posted March 13, 2006 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?
Vaughan Posted March 14, 2006 Posted March 14, 2006 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. :
Kent Searight Posted March 14, 2006 Author Posted March 14, 2006 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!
Recommended Posts
This topic is 7089 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now