Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
obriened83
Creator
Creator

Qlikview Server Performance Issue (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

14 Replies
Not applicable

Let me give you a screenshot.

Not applicable

qlikview.xcf

It calculate some statistic...the picture show the actual result from the file.

Not applicable

Any idea sir?

Thanks

Anonymous
Not applicable

Mohamed

I cannot open the screen shot you attached, but no worries, whet I need to know what this calculation is.

Is it a QlikView load script ?  If so then then please attach the script and the log file form when it is run.

Is it a QlikView chart ?  If so then can you attach the qvw ?

Is it something else ?  If so what.

Best Regards,     Bill

Not applicable

Is the screenshot helpfull sir?

qlikview.png