topic AW:Re: Performance estimation for a special QlikView case in QlikView https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225463#M77770 <HTML><HEAD></HEAD><BODY><P>HI Ekim,</P><P>is your application already running? If so, what is the file size? Based on that you can do simpl estimations on RAM usage.</P><P>From my experience: The largest application I ever saw used about 11GB RAM and the response time with concurrent users was only few seconds for getting full data list. Aggraget objects were much faster of course.</P><P>cheers</P><P>Florian</P></BODY></HTML> Wed, 09 Mar 2011 10:06:37 GMT 2011-03-09T10:06:37Z Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225457#M77764 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Could you please give me an approximate time or performance estimation for the following case:</P><P>For a QlikView system that has10.000 users, 1 of the users would like to get a report which contains 5 attributes and 2 metrics and that is using 3 tables, each containing data of 5M.</P><P>Thanks in advance,</P><P>Ekim</P></BODY></HTML> Tue, 22 Feb 2011 15:16:55 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225457#M77764 2011-02-22T15:16:55Z AW:Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225458#M77765 <HTML><HEAD></HEAD><BODY><P>Hi Ekimaparc,</P><P>I believe it is hard to give any estimation without knowing the underlaying hardware...</P><P>cheers</P><P>Florian</P></BODY></HTML> Tue, 22 Feb 2011 16:09:58 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225458#M77765 2011-02-22T16:09:58Z AW:Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225459#M77766 <HTML><HEAD></HEAD><BODY><P>Hi Florian,</P><P>All technical information is as follows:</P><P style="font-weight: bold; margin: 0cm 0cm 0pt">Technical Environment</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 72pt;mso-list:l0 level2 lfo1;tab-stops:list 72.0pt;">• <B>Database</B></P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 108pt;mso-list:l0 level3 lfo1;tab-stops:list 108.0pt;">• Oracle 11g - exadata - 1 TB warehouse (DWH), 1 TB summary warehouse (SWH)</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 108pt;mso-list:l0 level3 lfo1;tab-stops:list 108.0pt;">• SQL Server - 5GB metadata (MD)</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 72pt;mso-list:l0 level2 lfo1;tab-stops:list 72.0pt;">• <B>Hardware</B></P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 108pt;mso-list:l0 level3 lfo1;tab-stops:list 108.0pt;">• DWH, SWH - Sun 4500s, Solaris, EMC</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 108pt;mso-list:l0 level3 lfo1;tab-stops:list 108.0pt;">• App Server - Clustered Intel, Linux, EMC</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 108pt;mso-list:l0 level3 lfo1;tab-stops:list 108.0pt;">• MicroStrategy, MD - Intel, Win 2000 Server</P><P style="text-indent:-18pt;margin:0cm 0cm 0pt 72pt;mso-list:l0 level2 lfo1;tab-stops:list 72.0pt;">• <B>Software</B></P><P style="text-indent:35.4pt;margin:0cm 0cm 0pt 18.6pt;">Torrent Orchestrate, Informatica, MicroStrategy, IIS</P><P>will that information be enough to make an estimation?</P><P>Cheers,</P><P>Ekim</P></BODY></HTML> Wed, 23 Feb 2011 08:05:33 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225459#M77766 2011-02-23T08:05:33Z AW:Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225460#M77767 <HTML><HEAD></HEAD><BODY><P>I don't know how to make a quantitative estimate.</P><P>However, I'll guess less than a second based on experience with similar data volumes, at least to render the report itself. 15 million rows of data isn't that much data, the report sounds simple, and I'm guessing that your hardware is up to the task even though I know almost nothing about server hardware.</P></BODY></HTML> Thu, 24 Feb 2011 02:24:43 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225460#M77767 johnw 2011-02-24T02:24:43Z Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225461#M77768 <HTML><HEAD></HEAD><BODY><P>10,000 users?</P></BODY></HTML> Thu, 24 Feb 2011 02:57:50 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225461#M77768 2011-02-24T02:57:50Z Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225462#M77769 <HTML><HEAD></HEAD><BODY><P>Total number of users is approximately 10.000 but the concurrent number of users can be taken as max100.</P></BODY></HTML> Thu, 24 Feb 2011 10:24:44 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225462#M77769 2011-02-24T10:24:44Z AW:Re: Performance estimation for a special QlikView case https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225463#M77770 <HTML><HEAD></HEAD><BODY><P>HI Ekim,</P><P>is your application already running? If so, what is the file size? Based on that you can do simpl estimations on RAM usage.</P><P>From my experience: The largest application I ever saw used about 11GB RAM and the response time with concurrent users was only few seconds for getting full data list. Aggraget objects were much faster of course.</P><P>cheers</P><P>Florian</P></BODY></HTML> Wed, 09 Mar 2011 10:06:37 GMT https://community.qlik.com/t5/QlikView/Performance-estimation-for-a-special-QlikView-case/m-p/225463#M77770 2011-03-09T10:06:37Z