Dashboard Performance Issue on Access Point

[neha_shirsath]

Hello Community,

Need your suggestion on best way to worked my access point dashboard.

I have QV server installed on Windows server 2012R2 with 512GB RAM & 64bit OS.

And my application size is 824MB but it's takes time to load data on access point it always buffer after every selection.

So, what should I do to increase my dashboard performance on access point.

I've done the all optimization techniques to reduce application size but it has heavy calculation of front end which i can't do in back end.

Help me for other solution.

Any help will be great appreciated.

Thanks in Advance.

Neha D.

[arvind_patil]

Hi Neha,

May be you need to update your QlikView version. I have  faced the same issue on one of my client.

Thanks,

Arvind Patil

[marcus_sommer]

I think you will need to make the heavy calculations lighter by avoiding aggr-functions and nested if-constructs. Quite helpful could be to create flags within the script for the most heaviest calculations.

Another quite important point is the datamodel itself. If the gui is (too) slow you need to avoid link-table and/or snowflake models and going in the direction of a star-scheme or even a single table.

- Marcus

[neha_shirsath]

Yes I have used 2 link table but I cant avoid to used it because scenario like I have multiple dates coming from different table and calendar on multiple dates i.e i have created canonical calendar.

I tried with flag for heavy calculation but its not affect much in fact nothing.

Thanks for your help.

[neha_shirsath]

Thanks Arvind for your reply.

I'm not sure whether it will solve my issue or not that's why i'm holding this solution.