.qvf file converted from .qvw file runs very slow

[marychen]

After I convert a .qvw file into .qvf file, the .qvf file runs very slow upon open from the QS hub. Does anyone experience the same performance problem? The original .qvw file runs pretty descent speed in QlikView server. But, once convert into .qvf into Qlik Sense hub, it becomes super slow. Any idea what's going on and what needs to be changed to speed up the .qvf performance?

Thanks,

Mary

[bwisealiahmad]

Hi,

What do you mean "convert"? As in using the QV -> QS Converter or rebuilding the UI in QS?

Best,

Ali A

[marychen]

Use the QV to QS Converter in DEV Hub.

[rangam_s]

May I know place where it is slow?

Is it Slow while loading the data?

or

Is it slow in sheet object View?

[balabhaskarqlik]

May be, check the Operations Monitor App, you can point out any issues.

[marychen]

I stored all tables needed into QVDs and then load data from QVDs instead of loading data via SQL through ODBC. It doesn't help to speed up opening sheet object views. At this point, I am not sure which is causing it slow. Maybe both, maybe just sheet object view. There is if/else statement using the date variable where user needs to select a report date. All these run fine in QlikView but not after turned into Qlik Sense. Any suggestions on what can be done to fix this issue?

[ArnadoSandoval]

Hi Mary,

It seems that while opening the User Interface (Sheet Object View) QS is processing everything (all dates). I will suggest you to narrow the data by loading a single day, check performance (P1), second load a single month and check performance (P2), here you should find some performance differences, you may try loading a year getting (P3).

P1, P2 and P3 are the time to show the sheet object view. The result should help you to pinpoint the impact using the date variable.

I do not know the volume of data your application is handling, but you may consider implementing "AutoNumber" if the volume is high.

As a date is involved, I hope its selection is driven by a calendar.

Hope this helps,

Arnaldo

[balabhaskarqlik]

There are several reasons possible. One could be that your qlikSense server hadn't enough resources (CPU + RAM) at the time it happened - you will need to have a look within the task manager and in the qlikSense - and windows-logs if there is anything noticeable. Another reason might be that the connection/network and/or the queried database is in stable or too slow and you are running then in any timeouts.

Check your database-server and if it's then further unsolved you would need to check the network.

[balabhaskarqlik]

For the same dashboard, In Qlikview, Check the memory consumption of each object, On those objects, may be try to remove the expressions / disable in Qlik Sense and check the performance of Dashboard.

Check on, Objects with more columns and expressions, these effect the performance.