Jump to content
Sign in to follow this  
Matthew R White

Speed and summary calculations

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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