I have a dashboard that is connected to about 10 tables that pulls information in to give an overview. I had 7 portals that pulled information but then it starting to act slow, to non responsive when I started to counted my main table that had around 3K records.
I was able to create a workaround for counting all of the records by using the ValueCount method, and using a Script, Perform Find and set field for one of the count records that had a certain value.
However, one table I have is to count classes that have a value of 1 for a field, its no more than 10 but with a "Sum" calc field, a summary field, execute sql and portals all crash the dashboard. The class table contains no more than 800 records. I know the Count method counts and verifies all the records which slows it down. Doing another perform and find would just slow things even more, is there a faster solution to get the total of the fields that contain that 1 value. I also did a self-join relationship to that field but it was blank. I am using Filemaker Pro 13 connected to a server.