topic Re: Loading XML with QMC is slower than with client in QlikView

Loading XML with QMC is slower than with client

avkeep01 — Wed, 27 Aug 2014 11:55:10 GMT

Hi,

The application I created gets the data from a webserver by loading XML data from an URL. The script works fine.I get the correct data. But the problem is that reloading the application with the Qlikview Management Console is +/- ten times slower than loading the same data with te Qlikview client. The URL requires a data and a Employee number. For some of the application that number of employees can be more than 400.

When loading the data with the client it takes less than 2 seconds to load a particular part of the loop.

When loading the same script with the QMC then it takes 11 secondens.

What does the management console do different compared with the client? And can it be fixed?

Re: Loading XML with QMC is slower than with client

ashfaq_haseeb — Wed, 27 Aug 2014 12:04:38 GMT

strange

may be Bill Britt can help with some setting.

Regards

ASHFAQ

Re: Loading XML with QMC is slower than with client

Bill_Britt — Wed, 27 Aug 2014 12:17:00 GMT

Hi Anton,

I would think there is an issue somewhere and I would recommend you open a support case on it.

For now, I would use the qv.exe /r to reload it with a batch file.

Bill

Re: Loading XML with QMC is slower than with client

avkeep01 — Wed, 27 Aug 2014 12:20:46 GMT

Hi Bill,

Creating a batch file was my second option because there are 29 applications to reload. It is data of +/- 3.000 employees in total.

How can I open a support case?

Regards,

Anton

Re: Loading XML with QMC is slower than with client

ashfaq_haseeb — Wed, 27 Aug 2014 12:39:39 GMT

Look at below link

http://www.qlik.com/us/services/support

http://community.qlik.com/message/592155#592155

Regards

ASHFAQ

Re: Loading XML with QMC is slower than with client

Bill_Britt — Wed, 27 Aug 2014 12:45:29 GMT

Hi,

Can you create a QVW to load all the data and create QVDs for the other application to load from?

Bill

Re: Loading XML with QMC is slower than with client

avkeep01 — Wed, 27 Aug 2014 12:51:50 GMT

Hi Bill,

I kind of did the same thing. I have created an external .txt including the script and used an include statement in all the applications. At the first script tab I defined the different variables which are different for each application. I use multiple applications because if I use one application the reload will take multiple hours and it makes it unpossilble to reload a specific part of the data.

I testing the batch files right now and when they are faster then I can schedule them with the Windows Task Scheduler.

Regards,

Anton

Re: Loading XML with QMC is slower than with client

avkeep01 — Thu, 28 Aug 2014 06:52:44 GMT

Hi Bill Britt,

I have created some Batch files yesterday and according to the log reloading the same script as in the print screen where it takes only one to two seconds. So working with Batch files seems te speed the whole reload up.

Thank you.

Regards,

Anton

Re: Loading XML with QMC is slower than with client

Bill_Britt — Thu, 28 Aug 2014 10:36:54 GMT

That is great, but I would still contact support with the issue.

Bill

Re: Loading XML with QMC is slower than with client

avkeep01 — Mon, 01 Sep 2014 11:08:27 GMT

Hi Bill,

I have made a support case, they are already helping me. Thnx for your help.

Re: Loading XML with QMC is slower than with client

avkeep01 — Wed, 01 Oct 2014 14:33:09 GMT

Hi Bill Britt, just did some more exploration. I found that loading data from a specific URL doesn't create an error. Also when looking at that data with Internet Explorer does work. But when reloading the application with the Management Console I get the error "Download Failed". I have updated recently to QV 11.20 RS7 (both the developer as the server installation). And Im logged on to the server with the same account which runs the services. And that account is also admin on the server.

I also reopend the case, but maybe you know something more about this.

regards,

Anton