I have Year, YearMonth, and YearWeek tables that I use to total the count of Leads by agent. Then I bring these back in via an X relationship and a portal. However, when I click on the tab for the portal (each of the 3 above have their own separate tab), it takes about 3-5 seconds to show, thus it seems it is calculating.
The Year tab/portal has the slowest reponse time and even shows a "not responding" in FM. I even tried limiting it to only go back to 2009 and it shows little improvement. The LEADDATA table is 26,000 records, but I thought FM could handle that easily. Is there a better method than the one I'm using? See screen prints.
I've thought of making the calc fields stored, but that would work for the past numbers, but not the current year, month, or week. As I was doing the screen prints, I noticed that the flag fields are unstored. Orginally, those could change, but now we have a separate reassign field, so possibly I could store these. Any other suggestions?