Live connection - slow initial load times
I'm wanting to move from building an elasticube to using a live model. I'm noticing that initial load times across all widgets/dashboards are very slow on the first load, even when the query is quite small. Once cached, load times of course are quick. If I take the exact query and run it in a query editor, it completes in under 1s, so I would expect similar results from Sisense. Looking at the Chrome dev log, the bottleneck is 'waiting for server response'. We are connecting to a Redshift DB. Are there any configuration settings we should be looking at to reduce Waiting/TTFB?
