Load speed issue - Data Structure

[chris1987]

Hi,

I'm self-taught in QV so apologies now for any simple mistakes.

I have a database with millions of entries and although the performance of my app isn't terrible it takes about 7 seconds to load when a selection is changed.

I think I could improve my structure to help with this. Here's what I currently have:

All of the tables one the left are linked by the %Key, which links then to the MasterTable and then the MasterTable is filtered by other tables (my options).

I wondered if anyone could advise me what I could do to improve this structure? I'm fully up to speed with joins / union / concatenate etc. but I don't know what works best in QV, many small tables or one huge table? Maybe I could concatenate all the tables on the left?

Any tips / suggestions would really be appreciated.

Thanks

Chris

[Brett_Bleess]

Below is a post from the Design Blog area that may be of some use to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

I would recommend looking around in the Design Blog area for additional info as well, may be some other posts that that may be of additional help too, but hard for me to know exactly what you need, and I am not a very good developer myself, so hopefully this gets you on the right track with things. 

Regards,
Brett