Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhadrakas
Specialist II
Specialist II

Mapping Load very slow after migrating to QV 12.3

Hello Forum,

I have already migrated my QV Environment from QV 12.1 to QV 12.3 SR2.

After some tests i realized that some jobs has increaesed loading times.

After testing in detail i saw that only mapping load statements are causing that problem.

They need 3-4 times longer than before. 

Has anyone encountered this problem or has an idea to fix it?

Environment:

OLD: 1 Server with Publisher QV 12.1

NEW: 2 Clustered Servers QV 12.3 

Load times are increased when

- reloading via publisher
- reloading locally with Desktop Client

regards

tim

 

Labels (3)
1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II
Author

success!

i cannot reproduce the long loading times of mapping loads. But i dont know exactly which change resolved it.

the last changes i did were these: 

QVManagementService.exe.config

<add key="DocumentFolderAdminUseXDomain" value="false"/>

QVDistributionService.exe.config

<add key="QdsTempFolder" value="C:\ProgramData\QlikTech\DistributionService\1\temp"/>

Found it here:

https://support.qlik.com/articles/Basic/QlikView-Management-Service-Publisher-Related-Configuration-...

 

View solution in original post

2 Replies
Brett_Bleess
Former Employee
Former Employee

Tim, I have not been able to find anything in the Release Notes for 12.30 through SR3 related to Apply Map etc., nor did I really find anything in the 12.20 track either.  

There is a Design Blog post that may be worth reviewing to see if anything there gives you some ideas to try to improve things:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

I noted a change from 11.20 track to 12 regarding having expression arguments, but I was not sure if that was applicable in your case or not.  This one you may need to create a support case to allow us to look into things further.  One thing worth trying would be to pull the SR3 Desktop Client and run there just to be sure not something in there that changes behavior, that is the most current SR for 12.30 track.  Sorry I do not have anything better for you, I am not much of an expert on the development side of things unfortunately, so I do not know if there are some other optimizations you may be able to do or not.  My post will kick things back up in the list, so maybe someone else will have a look again and respond too.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
zhadrakas
Specialist II
Specialist II
Author

success!

i cannot reproduce the long loading times of mapping loads. But i dont know exactly which change resolved it.

the last changes i did were these: 

QVManagementService.exe.config

<add key="DocumentFolderAdminUseXDomain" value="false"/>

QVDistributionService.exe.config

<add key="QdsTempFolder" value="C:\ProgramData\QlikTech\DistributionService\1\temp"/>

Found it here:

https://support.qlik.com/articles/Basic/QlikView-Management-Service-Publisher-Related-Configuration-...