Huge table -> Qlik Sense to slow

[tnunes]

Hi, 

I have a dashboard, which selects about 300M (million) rows in the database.

Each row has 18 columns, and all columns are used in the dashboard. 

The data load takes some time (not use qvd), but is not an issue, the problem is the time to open the dashboard and see the data there.

What can I do to improve the performance? 

Thanks

[rwunderlich]

Analyze  your app with QSDA Pro. If your app takes a long time to open, I expect you have a lot of unique field values. See if you can reduce the number of distinct values.

-Rob

[fmarvnnt]

Use https://adminplaybook.qlik-poc.com/docs/tooling/cache_warming.html#cacheinitializer- 

with

-o 

parameter

before working hours and be sure there is enough RAM on the Server.

FMa