Can you utilize Tableau Server to create and manage Extracts from the data sources based on a schedule rather than utilizing live connections?
This document may help in designing well performing workbooks for this - Designing Efficient Workbooks | Tableau Software Check the sections under Data Server and Extracts.
I hope this helps.
Thanks for the reply. I am calling the stored proc on the spot since it requires live data connection. At least, if I created an extract for all of them, can I have it refreshed every 30 mins or so?