Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Showing top 5 without bogging down the server

Matthew R White
in Calculation Engine (Define Fields)

Featured Replies

I have a table with over 100,000 records and I'm trying to show the top 5 accounts by premium for each month in a portal.

One way of doing this is to create a portal and then filter the portals by premium size (so I get the top 5 at the top of the portal) and then filter or show only the top 5 records

I'm just worried that with the amount of data, every time this portal loads it will take significant calculations. Is there a better way to store this or create another table to keep the usability quick for my users?

Thank you in advance

Is the "premium" field stored? If not, that could be potentially the biggest performance hit.

You said top 5 for each month, does that mean one month per portal or what?

One alternate possibility is to run a script that returns the data via ExecuteSQL, e.g.:

SELECT account, premium FROM yourTable ORDER BY premium DESC FETCH FIRST 5 ROWS ONLY

...or something like that.

PS: it would help answer your questions if you update your forum profile with FileMaker version, OS, expertise level etc.

Create an account or sign in to comment

https://fmforums.com/topic/103775-showing-top-5-without-bogging-down-the-server/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.