One of the dashboards I am looking to create contains a grid of SingleStat blocks (10x12). Behind each block is a SQL query.
I can return all of the data for one row from one SQL query but because of the way the box works, I have to run 10 queries per row (12) per screen (3), so a total of 360 queries each minute.
Is there any way to reduce the number of SQL calls to about 1 per row (36)?
I wondered if it would somehow be possible to run a query and store each returned column in a variable array $myVariable(0), $myVariable(1) etc… Then I could wire up each SingleStat to variable.
Just a thought