Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
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: