Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
As we implemented a dedicated server for our Postgresql, is there a performance drop or increase. We recently changed our servers as part of windows EOSL. Even after our configurations are same we see most of our tasks are taking more than on the previous server. Wondering what could be the reason for this.
Do you mean the PostgreSQL as the metadata repository or data extraction?
Thanks Clever_Anjos.
PostgreSQL as repository
This shouldn´t impact that much (considering the PostgreSQL is in the same LAN/VLAN).
"taking more than on the previous server" how much time was added?
Old_Task Reload Time | New_Task Reload Time | |
Task 1 | 00:04:20 | 00:40:40 |
Task 2 | 00:00:18 | 00:02:53 |
Task 3 | 00:02:00 | 00:03:48 |
Task 4 | 00:01:03 | 00:01:43 |
Task 5 | 00:14:09 | 00:23:38 |
Task 6 | 00:07:48 | 00:09:35 |
Task 7 | 00:19:17 | 00:20:47 |
Task 8 | 00:14:06 | 00:15:37 |
Task 9 | 00:06:13 | 00:08:29 |
Task 10 | 00:00:11 | 00:01:29 |
Hi,
I would except the above sample reload time is sufficient enough to understand the problem. Please let us know if you need anything more on this. Thanks
Could you please check the app size for every task?
It´s odd that some tasks are consuming pretty the same time and other are taking much longer
Did you move the shared folder to another machine as well?
File Size (MB) | Old_Task Reload Time | New_Task Reload Time | |
Task 1 | 0.14 | 00:00:16 | 00:09:02 |
Task 2 | 2.52 | 00:00:18 | 00:02:53 |
Task 3 | 287.72 | 00:02:00 | 00:03:48 |
Task 4 | 34.88 | 00:01:03 | 00:01:43 |
Task 5 | 0.16 | 00:14:09 | 00:23:38 |
Task 6 | 0.15 | 00:07:48 | 00:09:35 |
Task 7 | 928.28 | 00:19:17 | 00:20:47 |
Task 8 | 229.89 | 00:14:06 | 00:15:37 |
Task 9 | 0.15 | 00:06:13 | 00:08:29 |
Task 10 | 0.14 | 00:00:11 | 00:01:29 |
We have moved the shared folder also to the new machine.
Besides tasks #1 and #2 now you are having pretty similar times, right?
Why the old_task reload time is so different your two tables? (today and tuesday)
We have almost 50 tasks which shows a difference in time, so as a sample I just included 10 tasks.
Task #1 was completing it's reload with 16 seconds (QlikView), whereas the new QlikSense has a reload time of 9 minutes, 2 seconds.
Please ignore the difference between tuesday and today, as I have considered different task for the fist task mentioned in the table