topic Re: Performance Queries in QlikView https://community.qlik.com/t5/QlikView/Performance-Queries/m-p/561872#M1269665 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Anyone can advise on this please.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 09 Sep 2013 01:57:39 GMT 2013-09-09T01:57:39Z Performance Queries https://community.qlik.com/t5/QlikView/Performance-Queries/m-p/561871#M1269663 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm assessing how much to scale my hardware by using a small deployment as a benchmark. I read from "DS-Technical-Brief-QlikView-Architecture-and-System-Resource-Usage-EN.pdf" and "BI-WP-QlikView-Scalability-Overview-EN.pdf" that performance is linearly proportional to a combination of RAM and CPU capacity.</P><P></P><P>I have some doubts and would appreciate if someone could explain to me.</P><P></P><P>1) Currently, my small deployment is about <SPAN style="text-decoration: underline;"><STRONG>10MB</STRONG></SPAN> and it takes <SPAN style="text-decoration: underline;"><STRONG>22 sec</STRONG></SPAN> for server to refresh data. Aggregation of data or selection is instantaneous. My objective is to find out what the performance is like if I increase the source data (and thus QVWsize?).</P><P></P><P>2) Assuming the worst case that I have:</P><P></P><P>QVWsize = 500MB</P><P></P><P>No. of concurrent users = 25</P><P></P><P>FileSizeMultipler = I am going to use 10 here since pdf states it's ranging from 2-10.</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Question 1: In fact, how do I decide what multiplier to use?</STRONG></SPAN></P><P></P><P>userRAMratio = I use 10%</P><P></P><P>Going by the formula as attached, the RAM i require will be 17.5GB.</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Question 2: As long as I have much more than 17.5GB in my server, the memory should be sufficient to achieve the same performance of 22secs right?</STRONG></SPAN></P><P><IMG __jive_id="46118" alt="formula.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/46118_formula.png" style="width: 620px; height: 249px;" /></P><P>3) I have not gotten to this step. But I know I need to measure the CPU utilization of my small deployment.</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Question 3:After which, I will need to scale by (500MB/10MB) to calculate the CPU required in my production setup in order to keep the same performance as my small deployment?</STRONG></SPAN></P><P></P><P>4) I saw this figure in your document:</P><P></P><P><IMG __jive_id="46119" alt="resp.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/46119_resp.png" style="width: 620px; height: 411px;" /></P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Question 4a: I assume sessions is equivalent to number of open QVW file?</STRONG></SPAN></P><P></P><P><SPAN style="; text-decoration: underline;"><STRONG>Question 4b:What is selection per session and how do I measure it?</STRONG></SPAN></P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Question 4c: This response time is referring to when users choose a new selection or when the server is refreshing data?</STRONG></SPAN></P><P></P><P>I know I am asking a lot of questions here. Hopefully someone will be kind enough to explain the above.</P><P></P><P>Thanks,</P><P>Steve</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Performance-Queries/m-p/561871#M1269663 2026-01-26T18:19:17Z Re: Performance Queries https://community.qlik.com/t5/QlikView/Performance-Queries/m-p/561872#M1269665 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Anyone can advise on this please.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 09 Sep 2013 01:57:39 GMT https://community.qlik.com/t5/QlikView/Performance-Queries/m-p/561872#M1269665 2013-09-09T01:57:39Z