Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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."
Hi guys
To resolve this I've contacted a Qliktech Solutions Architecht. He recommends not to use hyperthreading.
Hi guys
To resolve this I've contacted a Qliktech Solutions Architecht. He recommends not to use hyperthreading.
Sound strange, see link below, Regards
http://www.intel.com/en_US/Assets/PDF/perfbrief/mc_qliktech.pdf?wapkw=(qliktech)
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
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.
Very interesting indeed, thanks for sharing your results.
Did you guys do further testing? I was thinking of recomending gettinga dell server with E5-2690 & 256 GB ram
Hi Aji,
I would contact your account manager and see if he can provide you with official information.
Bill
Thanks Bill