Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
zhadrakas
Valued Contributor 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

 

1 Solution

Accepted Solutions
zhadrakas
Valued Contributor II

Re: Mapping Load very slow after migrating to QV 12.3

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
Highlighted
Digital Support
Digital Support

Re: Mapping Load very slow after migrating to QV 12.3

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
zhadrakas
Valued Contributor II

Re: Mapping Load very slow after migrating to QV 12.3

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