Last Calculation is very slow
I have a layout that uses a cartisian relation to show data in 4 portals by category. The categories are determined by a last () calculation field. This last () data comes from another related table. Each record on the parent table passes through 5 categories 1 at a time(a new record in the child table for each category).
It seems to me that the last () calculation is recalculating all the records everytime. The main table has about 11000 records and the child table has 12800 records. These 2 tables are growing very quickly and the last() calculation seems to be getting slower, which i would think it would. I have the last to recalculate as needed.
I am looking for a way to resolve this problem any idea would be a big help. I hope this is clear