I am using Bitnami Redash AMI in AWS Environment (t3.small). I am expecting large amount of data from one of my sources. How do I minimize the time taken for loading the results. Is it possible to control threads and memory read/write operations. Sometimes simple queries fail to load the results as the data is large.
I am going to be using these results in QRDS later, so memory write is required. But I observed that Loading results takes more time than the execution.
How do I improve the performance!!