Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
diwakarnahata
Contributor

Optimization by changing Metric Precision

Hi All,


gwassenaarjontydkpirwunderlich

I am currently working on optimizing an application which holds ~10 GB of uncompressed data.

There is a metric which is heavily used in almost all the expressions.

It has a precision of 6 digits of which the last 3 digits are always 0.

Will it provide any major optimization to reduce the precision to 3 digits?

It is wise to expect better CPU utilization after this change?

Regards,

Diwakar

Tags (2)
2 Replies
MVP & Luminary
MVP & Luminary

Re: Optimization by changing Metric Precision

Is that metric a field or the result of an expression? If you're talking about a field then I don't expect a large difference in performance by reducing the precision.


talk is cheap, supply exceeds demand
MVP & Luminary
MVP & Luminary

Re: Optimization by changing Metric Precision

I don't think it would make a CPU difference.

You may want to check the memory size of the field though. What is the current Symbol Width of the field? If it's not 8, then check the Document Properties, Number Format for the field. If its Mixed, set a numeric type.

-Rob