topic Re: what is performance tuning in qlikview project? in QlikView

what is performance tuning in qlikview project?

Tue, 12 Aug 2014 05:23:52 GMT

Hi,

Anyone please tell me.

Regards

Devi

Re: what is performance tuning in qlikview project?

Anonymous — Tue, 12 Aug 2014 05:34:15 GMT

Try read these links and also give more details when you post questions

Improving Qlikview Load Performance

QlikView Performance Monitoring

Qlikview performance

Re: what is performance tuning in qlikview project?

vardhancse — Tue, 12 Aug 2014 05:37:07 GMT

DB->QVD

Scheduling the task for reload

Re: what is performance tuning in qlikview project?

jagan — Tue, 12 Aug 2014 05:38:02 GMT

Hi,

Performance tuning means simply reducing the loading time of the charts and Dashboard loading time. Performance tuning in Qlikview is done at various stages, ie.,in front end and backend of the qlikview application.

Backend:

Do all the required calculations in the script itself.

Load only required data, for example if you are using only last 5 years data filter it out when you are loading data.

Load only required columns and tables so that Qlikview file size would be reduced.

If you are loading same tables in multiple dashboards then for the instance load from database and store it in QVDs and in other Dashboards load from QVD.

Frontend:

Use Set Analysis as much as possible.

Don't display all charts in a single sheet or provide buttons to show and hide the charts.

Don't display huge data in Tables, restrict user to do some selections so that the data would be reduced and load the table faster.

Limit the calculations in front end and move it to scripting.

Hope this helps you.

Regards,

Jagan.

Re: what is performance tuning in qlikview project?

Mon, 19 Jun 2017 21:31:01 GMT

helpful, thanks

Re: what is performance tuning in qlikview project?

vinod22kv — Fri, 06 Oct 2017 06:54:15 GMT

Thank its very helpfull