topic About the performance, is the script better than expression? in QlikView

About the performance, is the script better than expression?

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: About the performance, is the script better than expression?

Saravanan_Desingh — Wed, 03 Jun 2020 16:34:00 GMT

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.

Re: About the performance, is the script better than expression?

brunolelli87 — Wed, 03 Jun 2020 16:55:00 GMT

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

Re: About the performance, is the script better than expression?

Brett_Bleess — Thu, 25 Jun 2020 20:55:47 GMT

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-practices-data-modeling.htm

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

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