Jump to content

System becoming sluggish


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

Recommended Posts

Hi all

I have an issue where my layouts are starting to get sluggish on load and there is noticable flickering as scripts are executed. I'm unsure what element of my construction is causing this to happen. I am developing on the Windows platform.

All my tables are joined to two TOCs of themselves. One an equality join which checks for uniqueness (which I could do without and use native validation) and one a cartesian cross product join which is used for my archive.

I have four calculation fields in each table.

cActive = not Archived Automatically create indexes when needed

cCountRecords = Count ( ArchiveTOC::SerialID ) Unstored

cCountArchive = Count ( ArchiveTOC::Archived ) Unstored

cTotalActive = Get ( TotalRecordCount ) - Count ( ArchiveTOC::Archived ) Unstored

These fields are diplayed on my layouts using merge fields.

I have many tables, the more I build, the more sluggish the system performs.

How often are these unstored calculation fields updated? Is it solely when they are in use on a layout, or are they permenantly being calculated?

Could this be the cause of the sluggish performance? What would be suggested to increase performance in respect to loading layouts and speed of script execution?

Thanks in advance

Lee

Link to comment
Share on other sites

This topic is 4360 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.