I am having application of 2gb size. My server configurations are 32GB ram with 4 core cpu. To open file itself it is taking almost 10-12 mins.
While opening QVW, memory consumption is around 12GB and CPU utilization is only about 25-30%,rest will be idle. Why is it So? Shouldn't be QV using 100% of all cores while opening QV , if so then application could have opened faster.
I think that the FileOpen function in QlikView Server is only single-threaded. One core will do the loading, and this loading will be mostly I/O bound.
Only specific functions are multithreaded in QlikView Server and IIRC they deal mostly with searching and selecting. There is a nice article in HIC's series on the Design Blog. See here: The Calculation Engine