This is for a payroll type database (e.g. tracking salary over time). This is under FMS18, and the payroll table has about a half million records (about 4000 per month) The setup: There's a single Payroll table with one record per person per month it has a self relation Payroll Self by Last Mont…

Finds through relationships are slow

AndyHibbs December 21, 2020, 3:24pm 21

Yes, Wim that particular example makes perfect sense.

Topic		Replies	Views
R.I.P - GTRR Heads-Up! scripting , slowing	94	4887	March 7, 2021
FMS19.6.3 poor performance on M1 mini / Ventura Questions performance	45	1454	January 18, 2024
Increasing Performance for Complex Join Questions	19	422	March 26, 2024
Get (foundcount) calc field to count related records + bonus discussion about the ETS program Lounge (Discussions) performance	20	3163	September 7, 2020
Best Way To Implement Huge SQL Query In FIleMaker Questions sql	37	976	December 24, 2023