topic Re: Performance improvement from 11 to 12 in QlikView

Performance improvement from 11 to 12

Kushal_Chawda — Tue, 01 Aug 2017 09:47:39 GMT

Hi Experts,

I have few doubts regarding migrating from 11 to 12

How performance will be improved when we migrate to 12? Will it improve selection response time?

I just need to understand what performance improvements are done in QlikView 12

hic‌ rwunderlich marcus_sommer stalwar1‌ gwassenaar‌ troyansky

Re: Performance improvement from 11 to 12

Anil_Babu_Samineni — Tue, 01 Aug 2017 09:54:01 GMT

I know i am not the person who cares the Performance internally, But recently i came to know these?

When we upgrade to any recent version off course, There might be come advantages and disadvantages. I have gone this earlier. I got some changes and i clear to know those. I would simply ask you to read each and every point with Architecture and agenda by help of sticky paper to know the engine of Qlik products (QIX - Engine) Migration questions : Qlikview 11.0 SR2 to 12.1 SR3

Re: Performance improvement from 11 to 12

Kushal_Chawda — Tue, 01 Aug 2017 10:00:34 GMT

Hi Anil, thanks for your response. But my question is more on performance after upgrading to version 12.

Re: Performance improvement from 11 to 12

Chanty4u — Tue, 01 Aug 2017 10:12:09 GMT

bhai,

may be he will help you i believe

ghd

Re: Performance improvement from 11 to 12

Kushal_Chawda — Tue, 01 Aug 2017 10:25:54 GMT

Thanks chanty bhai

Re: Performance improvement from 11 to 12

Kushal_Chawda — Fri, 04 Aug 2017 13:44:01 GMT

Hello Experts,

any suggestions ?

Re: Performance improvement from 11 to 12

sunny_talwar — Fri, 04 Aug 2017 13:47:17 GMT

Adding few others

pcammaert‌

marcowedel‌

Re: Performance improvement from 11 to 12

marcus_sommer — Fri, 04 Aug 2017 14:19:18 GMT

Until now I have no own experience with QV 12. But AFAIK there are only slight changes by the engine from a performance point of view (mostly it was a harmonizing with the Sense engine) so that I wouldn't expect significantly performance differences between 11 and 12 within the most environments unless it's a multi cluster environment which should get some improvements (but this is just from hearsay).

- Marcus

Re: Performance improvement from 11 to 12

Kushal_Chawda — Fri, 04 Aug 2017 16:45:26 GMT

thanks Marcus for your reply. I have then another question, how QIX engine makes QV 12 different?

Re: Performance improvement from 11 to 12

marcus_sommer — Fri, 04 Aug 2017 17:36:32 GMT

I have seen a very good presentation from hic to the QIX engine by the qlik dev group meeting in Hamburg last year but don't remember it well enough in the details. Maybe Henric could give you an answer here.

- Marcus

Re: Performance improvement from 11 to 12

Oleg_Troyansky — Mon, 07 Aug 2017 15:57:51 GMT

In response to the original question - ver. 12 was largely about combining the engines and making both QlikView and Qlik Sense work on top of the same engine. With that in mind, you may not see any performance improvement at all.

The best way to know is of course to test both versions on your development server and benchmark performance of specific objects and applications.

I made my benchmarking on a very early release of 12.0, and I didn't find any performance gains. I haven't done any more testing with more recent releases, so it's possible that some new improvements have been implemented since then.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Boston, MA this October!

Re: Performance improvement from 11 to 12

phcaptjim — Thu, 10 Aug 2017 13:47:29 GMT

We recently upgraded from 11 to 12 and have not noticed any improvements. Also, we doubled the processors and RAM on our two beefy servers and that did not lead to better performance either. We might be working with QLIK to figure out the server issue but I think once you get to a certain level, the performance is what it is.