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.

search vs relationship: speed

  •
macavity
in Finding & Searching

Featured Replies

Hi! Given the alternative, which is the faster way to find records when working on a server with pretty hefty tables:

a) using a global field to set up an ad-hoc relationship

or

:) a scripted search in an indexed field using a variable?

Try it and see. The performance will depend on your situation. My hunch is that (;) will be quicker, but maybe not if you have to change layout and if the layout you change to has lots of unstored calculations or summary fields on it.

If you do scripted operations that require changes of layout, make a layout based on the desired table that is blank (no fields on at all). You'll usually find that it is quicker to search on the blank layoit than on one where the server has to go off and find data.

James

  • Author

I'd not thought of creating an extra layout for the search, but I'll do it. Thank you for a helpful reply!

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.