topic Re: Straight table loading time in QlikView

Straight table loading time

Anonymous — Tue, 10 Nov 2015 00:11:32 GMT

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 ?

Re: Straight table loading time

Anonymous — Tue, 10 Nov 2015 01:24:38 GMT

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?

Re: Straight table loading time

Gysbert_Wassenaar — Tue, 10 Nov 2015 08:46:10 GMT

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.

Re: Straight table loading time

miguelbraga — Tue, 10 Nov 2015 09:11:35 GMT

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

Re: Straight table loading time

Anonymous — Tue, 10 Nov 2015 19:16:48 GMT

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