I have a 90,000 records table of clients.
I do a ExecuteSQL() to fill up a multi-key field for relationship (only 100 records at a time). Takes 1 sec.
Fields for relationship are numerical (better performance than a text field? Or doesn't impact?).
But displaying the resulting tables base on the relationship take around 30s in the portal?
I have sort, filter and conditional formatting on this portal. But since it's only 100 records.
Can't find why this is taking so long.
Run on latest FMS 17 hosted on a fast server and really fast internet link.
Accessed from latest FMPa 17 on iMac (late 2012) with MAC OS latest also.