topic Re: Qlikview Script Load Very slow with Virtual server database in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Script-Load-Very-slow-with-Virtual-server-database/m-p/1431982#M430592 <HTML><HEAD></HEAD><BODY><P>It's hard to give much advise without more data:</P><UL><LI>What is the memory and CPU configuration of all the different servers - virtual and physical?</LI><LI>What is the size of the data extracted?</LI><LI>How does the QlikView load script look like?</LI></UL><P></P><P>Virtual servers shouldn't affect performance in such a dramatic way as you experience unless the virtual server is significantly under-powered in respect to RAM and or CPU.</P><P></P><P>I wouldn't agree that the numbers suggest that you can rule out network/resource issue?</P></BODY></HTML> Mon, 04 Sep 2017 19:48:12 GMT petter 2017-09-04T19:48:12Z Qlikview Script Load Very slow with Virtual server database https://community.qlik.com/t5/QlikView/Qlikview-Script-Load-Very-slow-with-Virtual-server-database/m-p/1431981#M430591 <HTML><HEAD></HEAD><BODY><P>Hello there.</P><P>We are finding that when running a script data load using a SQL database sat on a <STRONG style="color: #ff0000;">virtual</STRONG> server, it runs very <STRONG style="text-decoration: underline;">slow</STRONG> as opposed to running a script data load using a SQL database sat on a <STRONG>physical</STRONG> server.</P><P></P><P>For example :</P><P></P><OL style="color: #222222; font-family: arial, sans-serif; font-size: small;"><LI>QlikView SQL data load (3m+ records) on <STRONG style="text-decoration: underline;"><SPAN style="color: #0000ff; text-decoration: underline;">physical</SPAN></STRONG> server with database also sat on <STRONG style="text-decoration: underline;"><SPAN style="color: #0000ff; text-decoration: underline;">physical</SPAN></STRONG> server : <SPAN style="background-color: #ffff00;"><STRONG> 15 mins 8 secs load time</STRONG></SPAN></LI><LI>QlikView SQL data load (3m+ records) on <STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">virtual</SPAN></STRONG> server but with database sat on <STRONG style="text-decoration: underline;"><SPAN style="color: #0000ff; text-decoration: underline;">physical</SPAN></STRONG> server : <STRONG style="background-color: #ffff00;">16 mins 34 secs load time</STRONG></LI><LI>QlikView SQL data load (3m+ records) on <STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">virtual</SPAN></STRONG> server with database also sat on <STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">virtual</SPAN></STRONG> server&nbsp; : <STRONG style="background-color: #ffff00;">1 hour 9 mins load time</STRONG></LI></OL><P></P><P>Just as an additional test, I ran SQL extracts on both the physical and virtual database servers</P><OL><LI>Physical Server : SQL Select ALL on 3m+ records table : 3 mins 12 seconds</LI><LI>Virtual Server : <SPAN style="font-size: 13.3333px;">SQL Select ALL on 3m+ records table : 3 mins</SPAN></LI></OL><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">FYI we are running QlikView version 11.<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So it does seem to point to Qlikview as opposed to any network/resource issue. Would you agree ?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Is data load performance much slower with virtual server database as opposed to physical server database ?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">If so, is there a workaround ?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks in advance.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">regards</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Abdullah.<BR /></SPAN></P></BODY></HTML> Mon, 04 Sep 2017 10:39:18 GMT https://community.qlik.com/t5/QlikView/Qlikview-Script-Load-Very-slow-with-Virtual-server-database/m-p/1431981#M430591 aarshad67 2017-09-04T10:39:18Z Re: Qlikview Script Load Very slow with Virtual server database https://community.qlik.com/t5/QlikView/Qlikview-Script-Load-Very-slow-with-Virtual-server-database/m-p/1431982#M430592 <HTML><HEAD></HEAD><BODY><P>It's hard to give much advise without more data:</P><UL><LI>What is the memory and CPU configuration of all the different servers - virtual and physical?</LI><LI>What is the size of the data extracted?</LI><LI>How does the QlikView load script look like?</LI></UL><P></P><P>Virtual servers shouldn't affect performance in such a dramatic way as you experience unless the virtual server is significantly under-powered in respect to RAM and or CPU.</P><P></P><P>I wouldn't agree that the numbers suggest that you can rule out network/resource issue?</P></BODY></HTML> Mon, 04 Sep 2017 19:48:12 GMT https://community.qlik.com/t5/QlikView/Qlikview-Script-Load-Very-slow-with-Virtual-server-database/m-p/1431982#M430592 petter 2017-09-04T19:48:12Z