Jump to content

Massive slowdown


This topic is 5684 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I got a fairly simple database, 10 fields, two scripts, working great. It moves very fast, importing new records, and processing the records using the script. This was on a test file of about 1200 records.

However, I then tried running it on the full set, 61,000 records. It ran, but seemed very slow, which seemed reasonable considering the much larger set. However, I discovered an error in one of the scripts, so deleted all the records, and went back to testing with the test file. Now suddenly, the whole thing is moving like molasses, even though the big set is gone. I then tried saving the file as a clone, figuring maybe there was corruption in the file.

No go. Still the same snail's pace, even on just the original 1200 records. What's going on?

Link to comment
Share on other sites

Actually, you could always run a script that involved fields not on the current layout. There are a couple of script steps that won't work, such as copy and paste, but you get around that using the Freeze Window.

I involve fields not on the current layouts all of the time. Script steps such as Set Field do not require the field to be on the current layout. You can also Freeze Window, go to a layout, do a copy and paste, and return to the current layout, and the user will not see any of it.

HTH

Lee

Edited by Guest
spelling error
Link to comment
Share on other sites

  • 3 weeks later...

This topic is 5684 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.