Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Qlikview & Hyperthreading

Hi

I have not been able to find much information about Qlikviews utilization of Intels Hyperthreading, but from what i could find, it seems it should be turned off. Have you guys tested this or got some documentation on it?

Source: http://andpointsbeyond.com/2010/05/05/qlikview-scalability/

"Hyperthreading is designed to help deal with unoptimized applications and the limitations of operating system schedulers. My understanding from the last time that hyperthreading was actively marketed is that QlikView does not benefit and can actually suffer when hyperthreading is enabled. QlikView has highly optimized code and uses it's own threading algorithms to maintain peak performance. Hopefully someone from QlikTech can confirm in the comments that hyperthreading is not advisable."

1 Solution

Accepted Solutions
Not applicable

Qlikview & Hyperthreading

Hi guys

To resolve this I've contacted a Qliktech Solutions Architecht. He recommends not to use hyperthreading.

8 Replies
Not applicable

Qlikview & Hyperthreading

Hi guys

To resolve this I've contacted a Qliktech Solutions Architecht. He recommends not to use hyperthreading.

Not applicable

Qlikview & Hyperthreading

Not applicable

Qlikview & Hyperthreading

I have run into the same problem before and the solution is to turn-off hyper-threading. Also, I have found the six-core processors perform better than eight-core's for some reason. Although, I haven't tested any application in the new e7 family, sounds interesting.

Regards

Not applicable

Re: Qlikview & Hyperthreading

Despite the marketing hype in the Intel/QV pdf...

I did some load testing with Hyperthreading settings and the results were very interesting.

I scheduled 40 concurrent QVW reloads in the QDS (the QVW's generated data, wrote QVDs, read QVDs, and then logged stats).

The test hardware was a HP DL580 G7 with 4 X Intel Xeon Processor E7-4870 (4 CPU X 10 cores) and 256GB RAM.  By disabling hyperthreading, the average document refresh time went from 02:53 to 01:50.

danielrozental
Honored Contributor II

Re: Qlikview & Hyperthreading

Very interesting indeed, thanks for sharing your results.

Not applicable

Re: Qlikview & Hyperthreading

Did you guys do further testing? I was thinking of recomending gettinga dell server with E5-2690 & 256 GB ram

Employee
Employee

Re: Qlikview & Hyperthreading

Hi Aji,

I would contact your account manager and see if he can provide you with official information.

Bill

Not applicable

Re: Qlikview & Hyperthreading

Thanks Bill

Community Browser