Summary Fields slowing down my database
I have 5 portals on my layout, each with different portal filtering criteria. Above each portal I have summary fields (inside small portals with the same filter criteria) to found the number of portal records for each filtered portal.
These summary records seem to be slowing my database down immensely. Is there a better way to count my portal records so that my database doesn't slow down as much?
If you can re-create the filter criteria as a relationship instead, it should be faster to draw. A filtered portal really pulls all of the data in for every portal record, then filters it. A relationship will pull in the related records' data only.