Load speed issue - Data Structure

chris1987 — Sat, 16 Nov 2024 21:02:22 GMT

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

Re: Load speed issue - Data Structure

Brett_Bleess — Wed, 29 May 2019 13:54:12 GMT

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

topic Load speed issue - Data Structure in QlikView

Load speed issue - Data Structure

Re: Load speed issue - Data Structure