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.

Unpredictable sorting slowness, goes away on restart

Featured Replies

The setting:

FMS 5.5 on Windows

FMP 5, 5.5, 6 clients for 5-10 users on Windows

Server and all clients appear to have adequate memory; network performance is strong.

The problem:

Sometimes, when a user views a layout that includes a portal showing join records in a file with a large number of records, FileMaker pops a "Sorting..." progress dialog, that counts down from a number in the thousands, then goes away. This is not surprising in some cases, since the portal shows records in a particular sort order, and there are a lot of join records, and over a network these things can take time.

Here's the mystery:

It doesn't happen all the time or for all users!

Here's the pattern I've figured out so far:

1. A user can launch the database and browse records for hours without seeing the sorting dialog (or having to wait for it to finish).

2. After editing a record or creating a new join record, the sorting slowdown begins... even on the same records and layouts that had better performance in 1. above.

3. Another user can be looking at the same records on the same layouts at the same time, and not experience the sorting slowdowns.

4. Any user who's started experiencing the sorting slowdowns (which become chronic and sap performance enough to be a serious problem) can make them go away by quitting FileMaker and opening the database again.

My client and I have been experimenting, yet we can't find a way to avoid these chronic "Sorting..." dialogs, aside from restarting FileMaker.

Is this problem familiar to anyone? Does anyone know a work-around whereby we could avoid the chronic sorting and attendant dialogs?

Thanks in advance,

Allen

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.