Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks, Jagan,
I have already tried this but not the Calculation Condition can you please explain how can one use it .
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.
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.
try moving all expression into script.
try to merge tables if posible
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
The data model is best and looks neat and clean with all precaution of scripting.
Seems that can be a option but it will only make things complex
Folks,
what about using the qvd?
Do they can help in this case ?