Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Performance Issue

Hello All, we have a peculiar QV performance issue.

We are running QV 10.4 in our production, test and development environments.

Production Server specs:

64 bit OS

Windows Server 2008 R2 Enterprise

2 CPU quad core: Intel Xeon X5560, 2.8 GHz processor

192 GB RAM

Developer Workstation specs:

64 bit OS

Windows 7

2 CPU quad core: Intel i7-2600, 3.4 GHz Processor

16 GB RAM

Building QlikMarts takes 2 to 3 times longer on the production server compared to the developer desktop. We benchmarked performance using a particular QlikMart. It takes 6 hours on the production server and 2 hours on the test server. We installed the QVS server on the developer workstation and still the same result.

Any idea what could be causing slowness in creating QlikMarts in production class servers?

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

We have found that new workstations / desktops using i7 processors provide much better performance compared to older servers with Xeon processors.

View solution in original post

2 Replies
Not applicable
Author

We have found that new workstations / desktops using i7 processors provide much better performance compared to older servers with Xeon processors.

StefanBackstrand
Partner - Specialist
Partner - Specialist

Nice find! This is actually something that's more important than many seem to believe. Focusing too much on CPU frequency/clock speed and/or socket/core count is just not enough. Processor generations, memory architecture and other hardware differences are very important to all take into account when benchmarking.

/edit: Saw now that this was over a year old, I wonder why it showed up in my feed just now.. ?