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.

Seeking clarity and/or opinions on "auto-sorting"

Featured Replies

Hi all -

I believe it was FM10 that introduced the feature where FileMaker maintains the sort order, if the records are sorted, on a layout automatically. So, if you have a window that setup to show records in list view and you sort those records, FileMaker automatically re-sorts when you modify the data in field(s) that the layout is sorted by.

I hope I explained accurately.

Anyway, I'm using FM11 currently and I'm wondering what effect that feature has on performance if you have 50 people that all have that same window visible all the time. I guess I want to know what exactly triggers that re-sort. Is it possible that all 50 workstations would try to re-sort at the same time? If so, it's my understanding that the workstations do the sorting, so even if they all re-sorted at the same time, would that cause a general performance issue?

It should be said that the number of visible records in the list at any moment in time is about 2000 on average. So, even if there are several hundred thousand records in the table, it's a fairly small subset of those records that are in the found set at any one time.

Would it be better to use a portal to show them these records in a sorted order? Does that gain anything? I try to avoid using sorted portals when possible as I've seen worse performance with these which is why I went with a list view instead of portal.

Anyway...I'd love to hear what you guys have to say. Feel free to correct any statements I made above. I'm not above being wrong.

Create an account or sign in to comment

Important Information

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

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.