Live connection - slow initial load times

[cglowe]

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?  

[DRay]

Hello @cglowe,

Thank you for your question. Are you using the official Sisense Redshift connector?

[cglowe]

@DRay We are using the official Sisense Redshift connector.

[DRay]

Ok, excellent. Have you opened a support case for this yet? The support team can look at logs to help determine what the cause of the issue is and provide possible solutions. This document may help also. https://community.sisense.com/t5/knowledge/how-to-diagnose-slow-dashboard-load-time/ta-p/3148