Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
avkeep01
Partner - Specialist
Partner - Specialist

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?

1 Solution

Accepted Solutions
Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

10 Replies
ashfaq_haseeb
Champion III
Champion III

strange

may be Bill Britt can help with some setting.

Regards

ASHFAQ

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
avkeep01
Partner - Specialist
Partner - Specialist
Author

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

Bill_Britt
Former Employee
Former Employee

Hi,

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

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
avkeep01
Partner - Specialist
Partner - Specialist
Author

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
Partner - Specialist
Partner - Specialist
Author

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

Bill_Britt
Former Employee
Former Employee

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

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
avkeep01
Partner - Specialist
Partner - Specialist
Author

Hi Bill,

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