topic Re: Performance with Set Analysis. Number VS String in App Development

Performance with Set Analysis. Number VS String

Xabinav — Wed, 02 Feb 2022 16:09:57 GMT

Hi everyone

I'm trying to improve App performance, a lot of the "Set Analysis" are with a string.

I wonder if switching to a number will improve performance

for example -

Now --> Count ({<approved = {'yes'}>} Orders)

Change to -- > Count ({<approved = {1}>} Orders) (1 = Yes , in Data model)

Will it improve? In reality the formulas are longer...

I would love to know if there is a tool or way to measure performance improvement

Thanks

Re: Performance with Set Analysis. Number VS String

rwunderlich — Wed, 02 Feb 2022 18:48:06 GMT

In set analysis, there is no difference in performance between using string and numeric for modifier values. The internal logic always uses a string test.

You can measure expression performance in your app using QSDA Pro. Another tool for doing command line expression performance testing is CubeTester.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Performance with Set Analysis. Number VS String

Xabinav — Thu, 03 Feb 2022 08:47:52 GMT

Thank you Rob !