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.

[jagan]

Hi Sujeet,

Check this Sheet Properties-> Objects -> and check Calc Time of the objects which are taking more time and try to optimize those charts, if it is Pivot tables then show less data by making selections by using

Chart Properties-> General-> Calculation Condition

Hope this helps you.

Regards,

Jagan.

[sujeetsingh]

Thanks, Jagan,

I have already tried this but not the Calculation Condition can you please explain how can one use it .

[jagan]

Hi Sujeet,

Suppose if you have pivot table showing all the data then the performance issues may arise, so restrict the display of records by asking user to select some filters to limit the data in tables.

Calculation Condition = Count(ID) < 10000 (Now if the possible records is less than 10000 then the pivot table is displayed with data otherwise it shows error message)

Hope this helps you.

Regards,

Jagan.

[vinay_hg]

hi sujeet,

can you brief abt data, how many tables?, what kind of data schema you have created with that? how you are loading these data into dashbaords.?

in qvw

use less if condition, use set analysis

how many users are accessing? check in the peak time what is ram usage by your dashboard.

if you provide all these details then it will be helpful to resolve the same.

[SunilChauhan]

try moving all expression into script.

try to merge tables if posible

[sujeetsingh]

Jagan,

Is the objects are too weak in memory point of view that they can not represent lacks of records.?

I need to show all records

[sujeetsingh]

The data model is best and looks neat and clean with all precaution of scripting.

[sujeetsingh]

Seems that can be a option but it will only make things complex

[sujeetsingh]

Folks,

what about using the qvd?

Do they can help in this case ?