Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the determinant factor about open a qvw and a object?

Hi guys,

When I open a qvw file(about 20MB) from qv developer client, it costs about 30 seconds to open, and another objcet cost 15 seconds to open, I want to know what is the determinant factor about this?Why it is too slow?

Can someone help me?

Thank you very much.

1 Solution

Accepted Solutions
Not applicable
Author

Hello,

QVW file is pre-loaded with data and when we open it, it uses the cached data model and data inside the QVW file. If you again open the QVW file, it will get opened more faster since it is now in system cache now.

When we play around with objects then following factors are considered:

1) Majorly depends upon performance degrading expressions being used at object level.

2) How efficient is the data model and is it well connected as per requirements.Sometimes all best practices get failed, if our data model is not well connected.

3) It also depends upon of RAM configuration of the system.

Try modifying the Object with better expressions.

Thanks,

Angad

View solution in original post

4 Replies
sujeetsingh
Master III
Master III

It may due to the lots of data in your qvw and the most important thing is the configuration of your machine .

Not applicable
Author

Hello,

QVW file is pre-loaded with data and when we open it, it uses the cached data model and data inside the QVW file. If you again open the QVW file, it will get opened more faster since it is now in system cache now.

When we play around with objects then following factors are considered:

1) Majorly depends upon performance degrading expressions being used at object level.

2) How efficient is the data model and is it well connected as per requirements.Sometimes all best practices get failed, if our data model is not well connected.

3) It also depends upon of RAM configuration of the system.

Try modifying the Object with better expressions.

Thanks,

Angad

giakoum
Partner - Master II
Partner - Master II

see attached for optimizing

Not applicable
Author

Hi,

Thank you for your help.