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.

Calculations that SLOW db down. Fix How?

Featured Replies

  • Newbies

Hello,

I am developing a system that tracks payments and balances due or owed on a monthly basis. I'm using relationships/calculations that look back to previous months to bring balances due or owed into the most recent month. The problem is, the db slows down during data entry on these pages. If the user does data entry that will change the balance, the db takes some time to refigure the balance. I want the user to be able to fly through data entry and to not have to pause while the db recalculates. I can't figure out if this is a common problem and I need to figure out a work around using scripts to set the balances in number fields to speed things up - OR if I am going about the way I have set the calculations and relationships incorrectly. Please advise or show me examples of a similar system. I hope I have explained my problem clearly enough! THANKS

Create an account or sign in to comment

Important Information

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

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.