About the performance, is the script better than expression?

[brunolelli87]

Hello guys,

I'm creating a personal project using QlikView, and I'm connecting multiple excel CSV files, with some external databases, and I'm facing some performance issues. 

Like when you select something on a chart and you see that "progress bar", you know..

So, I'm thinking about converting as much as possible of my expressions to the script.

What do you guys think about it?
Is it really better?

Thanks

[Saravanan_Desingh]

If you bring most of your logic into Script and make the front end lite, the Object refresh time will certainly reduce. I will do most of my cases like that.

[brunolelli87]

But your file's size will increase, right?

So, basically I'm understanding that there is no direct relationship between the file's size and the refreshment time.

Thanks
Bruno

[Brett_Bleess]

Check the following links, will hopefully be of some help to you:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-p...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/application-per...

You may want to search the Design Blog area too, might be some posts there that will be helpful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett