Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

avkeep01
Valued Contributor

Loading XML with QMC is slower than with client

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.

loadtime_XML_normal.jpg

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

loadtime_XML_slow.jpg

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

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Loading XML with QMC is slower than with client

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

10 Replies

Re: Loading XML with QMC is slower than with client

strange

may be Bill Britt can help with some setting.

Regards

ASHFAQ

Employee
Employee

Re: Loading XML with QMC is slower than with client

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

avkeep01
Valued Contributor

Re: Loading XML with QMC is slower than with client

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

Employee
Employee

Re: Loading XML with QMC is slower than with client

Hi,

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

Bill

avkeep01
Valued Contributor

Re: Loading XML with QMC is slower than with client

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

avkeep01
Valued Contributor

Re: Loading XML with QMC is slower than with client

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

Employee
Employee

Re: Loading XML with QMC is slower than with client

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

Bill

avkeep01
Valued Contributor

Re: Loading XML with QMC is slower than with client

Hi Bill,

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

Community Browser