Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

obriened83
Contributor

Qlikvew Server Performance Issues (Preceding Loads)

Hi

I was wondering if someone could please help me in figuring out this perfomance problem. We currently have Qlikview 10 SR4 installed on our Sever with the following hardware and settings

  • 40 Physical Core Processors (Intel(R) Xeon CPU      E7-4870 @ 2.4GHz)
  • 512 GB of RAM
  • 64 Bit Operating System
  • Hyper Threading disabled

The problem lies in the fact that my local PC (4 Cores Only) can load un-optimized QVDs faster than the Server. Some load time differences could be over 2 mins compared to 30 seconds on the local PC.

The problem seems to lie in Qlikview's Preceding Loads. For Example loading data from the Data Warehouse is almost ten times faster on the Server when you do not have a preceding load in front of the SQL query. You would expect way better performance from such a powerful Server.

I would greatly appreciate it if anyone can help me solve this performance problem. Thanks again.

Kind Regards

Eamonn