Qlik Client Managed poor performance post application DB migration to AWS
Please see below two scenarios and kindly advise.
1] Qlik Sense Client managed connecting to PostgreSql database which is on prem and connected through ODBC connector: Reload takes 20 minutes.
2] The application database is now moved to AWS instance and we are using default QlikSense PostgreSQL connector to connect to this AWS hosted database. The same reload script is now taking 6 hours to reload so there is considerable degradation of performance.
What could be the key factors affecting the performance.
Have you tried exectuing the same query in a query editor that is not qlik, for comparison? It's not necessarily qlik that is the source of your problem.
Does the query take a long time to compute in the database, or is it a vast amount of data in the result that is being transferred? It is highly likely that data transfer speed is a lot(!) faster within your on prem network compared to remote AWS.
