Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight table loading time

I have a straight table with 15 dimension and one expression which shows the URL , the table has 10k rows the load time really slow , can I know why ? 10k is not really a large data set right ?

4 Replies
Anonymous
Not applicable
Author

Open the Document Properties, go to Sheets, select the sheet where your problematic table is located, and then select the object (table) in the lower box. What does the CalcTime and Memory show? Is the memory greater than the available system resources?

Gysbert_Wassenaar

The 10k rows are the result of calculations involving 15 dimensions (which is quite a lot for a chart) and an unknown number of records. Your data model could have millions of rows involved in the calculation of the expression results. Your data model could be very complicated with dozens of tables associated in a extremely snow-flaked model.


talk is cheap, supply exceeds demand
miguelbraga
Partner - Specialist III
Partner - Specialist III

Can you please show us a snapshot of your data model. As gwassenaar‌ have said, it could be the complexity of your data model that slow it down your loading time

Anonymous
Not applicable
Author

My data model if a concatenation of 6-7 tables .. is that the reason for slow ness?