Jump to content

Speed and summary calculations


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

Recommended Posts

Hi everyone, thank you in advance for your help and support!

I have a field called Total Premium and over 10,000 customer records in my database.

I use a card layout as a "Dashboard/Summary" to show sales and other data for the month.

Currently my script is as follows, new layout/card, enter find mode, find records with dates for this month. perform find.

At this point for about 12-15 seconds filemaker is spinning in the background summarizing the Summary:Total Premium Field and then the data is displayed perfectly.

Is there a better/quick way to calculate and store this data on the fly, perhaps on the server or in a table that makes this summary screen faster to load?

 

Also, does anyone know of an article or post that's dedicated to what slows databases down and how to optimize your database?

I am opening up a branch office in Alaska next year and if loading this dashboard takes 12-15 seconds while connected on wifi to the server, it will take many minutes logging in remotely from my team in Alaska

Thank you!

Link to comment
Share on other sites

This topic is 1944 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
×
×
  • Create New...

Important Information

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