Amazon Cloud PostGres DB from Prod and Dev Very Different Load Times
Gurus,
I have a query that reads from an Amazon cloud PostGres DB. Our prod and dev environments are on the same (physical) server. The load time from prod takes 3X more time than from dev. The prod version load time is over 6 hours yet the same code in dev takes just over 2 hours consistently.
Any thoughts on the cause for this difference? Our QV admins, as well as the DBA, don't seem to have a clue and have opened a case with Qlik Support but that may take a while to figure out.
Firstly the best practice is to have the server dedicated to one site. That way can make sure the hardware resources are for the specific qlik sense server only while avoiding the conflict. Also for each site, the architecture can be different.
For PROD, you can look at the number of nodes, the number of scheduler nodes and engine nodes. Same to DEV. When reload the task, the task will be run on scheduler node. When reload in data load editor, it will run on engine node. So if the site has more nodes to balance the workload, the data load will be quicker.
You can also check which node exactly the data load take place. Compare the data load or scheduler load logs to see the difference. Compare the hardware resource as well.
As you said, if both PROD and DEV are on the same server, beside checking logs, you can also check the timing. Are both data load tested at the close timing. At that time, any other process running as well which may impact the performance.
Hope this helps
Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
