Solved: Qlikview Server response time - Qlik Community

mohamed_ahid · ‎2019-09-25

hello ,

Actually i'm working on a sizing and trying to define the best one for the choosen architecture .I need to have your opinion what should be the correct/acceptable response time in normal condition and when the server is highly stressed for these actions :

Acces point opening

launch an application

Applying a filter

Thank you gys

marcus_sommer · ‎2019-09-26

Your question is much too general and it depends on multiple factors if the response-times are acceptable or not and most often it relates to the expectation of the users and if there are other better performing alternatives available or not.

For power-users may an average response-time > 1 second a bit slowly but for many users are response-times < 5 seconds absolutely ok. because they aren't quick enough with their comprehending what they are doing and which results they get. Even response-times which are significantly > 5 seconds make many users happy because they waited for minutes or even hours to get such views with other tools like SAP BO / BW or any databases.

Beside this the essential fact will be always that you need a well designed environment with optimized applications to get a good performance. With poorly designed environments/datamodels you get each tool down - even Qlik.

- Marcus

View solution in original post

ramasaisaksoft · ‎2019-09-26

Hi Mohamad,

Could you please elaborate , what you are exactly expecting?

You are asking about the application (abc.qvw) size <1 GB for a good performance.

Maintain The Folder structure (3 Tier Archit)

QVD Generation
Transformation
Data Model
Application
Reduce calculations in UI level (Finish calculations in Back end... i mean in script it self.) call the calculated values with the help of Field names or variables
Size of the application (Remove unnecessary Fields from Data model, Remove synthetic keys & Circular loops, Archive the data means if you have Huge amount of data then reduce the data for 2 years like that...
Good Size of Server RAM will help you
(or)

searching for QV server Configuration to maintain the application in Run time without any troubles.

correct me if i was wrong,so that our Qlik folks will help you according to that.

mohamed_ahid · ‎2019-09-26

Hi Ramasaidaksoft,

Thank you for your response .

I'm trying to get opinions about what should be the acceptable response time regarding qlikview technology (associativity,in memory technology) .My question is have no concerne about the server config and the amount of data .

Regards

marcus_sommer · ‎2019-09-26

Your question is much too general and it depends on multiple factors if the response-times are acceptable or not and most often it relates to the expectation of the users and if there are other better performing alternatives available or not.

For power-users may an average response-time > 1 second a bit slowly but for many users are response-times < 5 seconds absolutely ok. because they aren't quick enough with their comprehending what they are doing and which results they get. Even response-times which are significantly > 5 seconds make many users happy because they waited for minutes or even hours to get such views with other tools like SAP BO / BW or any databases.

Beside this the essential fact will be always that you need a well designed environment with optimized applications to get a good performance. With poorly designed environments/datamodels you get each tool down - even Qlik.

- Marcus