Performance Issue UI

[sujeetsingh]

Hello Everyone,

I just have qvw file with 60k records. I deployed it with hardware configuration as 16 GB RAM and multiple CPU.

Now the UI click and selection are too slow. The UI contains

--7 to 10 tabs

--some are hidden

--on field triggers too

--Print reports for each tab

--Pivot tables on each tab

--all objects have multiple (dimension near about)

--Expression is count distinct

Now i want to see that can we enhance the UI clicking and navigation.

[#2]

Hi sujeet,

to Optimize your qlikview application please follow the checklist given in the attached document

Regards,

Vivek

[jagan]

Hi Sujeet,

If you are displaying all the records in the Straight/Pivot/Table box then definitely the performance issue occurs.  So better restrict the data in Tables.

Regards,

Jagan.

[#4]

It depends upon till what level the data model is normalized. More the de-normalized data model, more faster processing.

Also, for a most of the common dashboard information, how much nodes of data model qlikview has to traverse.

Thanks,

Singh

[sujeetsingh]

Vivek i have already gone through these stuffs

[sujeetsingh · Accepted solution]

Thanks ,

All friends for your help and zeal to help. I was just expecting some tremendous trick or experience from any one who have optimized a pre existing report.