Slow calculations

I have some fairly simple calculations on a page using server connect data. For some reason a few are taking around 10 secs to load showing “Invalid Number” until they do…

https://portal.rare.org/data-management/savings_clubs_stats/sc_totals.php

Here’s an example of one of the calculations…

dmx-text="((sc_bra.data.query_bra.total_savings.toNumber() * 0.19) + (sc_hnd.data.query_hnd.total_savings.toNumber() * 0.0419) + (sc_idn.data.query_idn.total_savings.toNumber() * 0.0000689) + (sc_moz.data.query_moz.total_savings.toNumber() * 0.0157) + (sc_phl.data.query_phl.total_savings.toNumber() * 0.02)).formatNumber(0, '.', ',')"

It’s basically pulling totals from the same dataset but multiplying by different values based on currency exchange rates, and then adding them together to get the total in US$. The MySQL View which generates the data only takes 2 secs to load so it looks like it’s the actual calculations.

Any help appreciated as always.

Community Page
Last updated: