Better way to retrieve data

[wispy hare]

You could queue this/run it from crons. Save the datas in a json file and load the JSON datas from your dashboard.
We have a dashboard with tons of products stats. Stats are updated each 01 of month so it takes pretty much long time.

[wheat stone]

Is there a way to preload the data into an array without running it in the for each? Obviously the above code is making multiple connections to the database for each user