Two Tier VS Three Tier Architecture's Performance

[Purushothaman]

Hello Experts,

I've developed a Qlik Sense app using a Two-Tier Architecture. The app has 12 million rows, 5 sheets, and is 1.64GB in size.

The architecture consists of:

1. Extract Layer for storing into QVD.
2. Data Model Layer and Dashboard Layer.

Despite optimizing the QVD and the app, I've noticed slow loading times and delays in applying filter changes. I'm considering converting it into a Three-Tier Architecture for better performance:

1. Extract Layer for storing into QVD
2. Data Model Layer
3. Binary Load: (Data Model Layer) Dashboard Layer

Do you think this change could improve performance? Any insights or suggestions would be appreciated.

[rwunderlich]

This change will likely not have any impact on the chart runtime performance. 

-Rob

[anat]

there will be no much improvements as per above approach,

you may need to enhance your application for better performance. 

[sidhiq91 · Accepted solution]

@Purushothaman  A better Data model layer will reduce run time and increase the performance of the App.

1. Avoid Vizlib objects in the Sheet, using QS native objects instead.

2. Use Resident loads in the Data model layers instead of using the same tables.

3. If any Composite Key is used, use Autonumber to create a key.

3. Keep an eye on the types of join being used.

[rwunderlich]

@sidhiq91 "A better Data model layer will reduce run time and increase the performance of the App."

How so?

-Rob

[sidhiq91]

@rwunderlich From my experience, I have observed that if the data model is designed well it would definitely reduce the run time of the App. 

The Presentation layer will face Latency issues if there are plenty of Vizlib objects and have complex coding.

Please correct me if I am wrong.

[rwunderlich]

@sidhiq91 "From my experience, I have observed that if the data model is designed well it would definitely reduce the run time of the App."

I agree. The reason I was asking for clarification was that the OP asked about switching from a 2-tier to a 3-tier architecture which would not change the data model in any way.  

-Rob