topic Re: Row_based qvd optimized in QlikView

Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 19:25:27 GMT

Hi Team -

I was loading something from a qvd and saw this:

I have seen (qvd optimized), but not row-based qvd optimized. Is this new? What is the difference between qvd optimized and row-based qvd optimized?

Thanks,

Sunny

Re: Row_based qvd optimized

Anonymous — Fri, 11 Dec 2015 19:27:10 GMT

Is this using QV12 ?

Re: Row_based qvd optimized

Peter_Cammaert — Fri, 11 Dec 2015 19:27:26 GMT

Using QV12 already? I would like to know this too.

Re: Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 19:28:09 GMT

Yes, in QV 12

Re: Row_based qvd optimized

Anonymous — Fri, 11 Dec 2015 19:32:56 GMT

Ain't used QV 12 yet, but saw hic talking about it using the new QIX row based engine at the QlikDev London Group a few months ago.

So this looks like it is a loading a [QIX] row based QVD.

I would guess you created your QVD with QV 12.

What text message do you get if loading a QV11 created QVD ?

Re: Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 19:33:54 GMT

I can check and revert back in a minute

Re: Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 19:36:00 GMT

Loading a qvd generated in QV 11.20 into QV 12 still shows row-based qvd optimized.

Re: Row_based qvd optimized

Peter_Cammaert — Fri, 11 Dec 2015 19:36:57 GMT

Bill,

has the QVD layout changed in QV12?

Re: Row_based qvd optimized

Anonymous — Fri, 11 Dec 2015 19:42:51 GMT

I have never used QV12 so cannot advise.

I am intrigued by the new QIX engine though, maybe hic can illuminate us. A Blog Post from him about it would be great,,,,,,,,,,,,,,,

Re: Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 19:44:18 GMT

Agreed. It would be good to know the differences and also if the other one still exists or is it the same thing with a different name.

Re: Row_based qvd optimized

rwunderlich — Fri, 11 Dec 2015 22:16:20 GMT

I think what you are seeing is just a new message. "Row based" QVD is the traditional QVD. For a while, Qlik Sense flirted with a "column based" QVD format. Sense 2 is now back to the row format.

QV12 can read either row based QVDs (created by QV11, QV12, Sense 2) or column based QVDs (created by Sense 1).

I believe the message is only telling you which format of QVD was detected.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Row_based qvd optimized

sunny_talwar — Fri, 11 Dec 2015 22:47:35 GMT

Rob - thanks for your response.

What exactly does it mean that a qvd was created row based vs. a qvd was created column based?

Re: Row_based qvd optimized

rwunderlich — Fri, 11 Dec 2015 23:53:20 GMT

It's the internal format of how the data is arranged for performance reasons. I think the only product that produced column based QVDs was Qlik Sense V1. As a practical matter, we as QV developers only care about this for compatibility concerns. You don't get to choose one format or the other. QlikView 11 can't read column base QVDs and therefore can't read Qlik Sense V1 created QVDs (V2 ok). QV12 can read both column and row QVDs, so no issue.

I'm surprised that they even bothered to put "row based" (since it's the default that requires no extra processing) in the QV12 message, but perhaps I'm overlooking something. Maybe someone who knows more about this than I do will chime in.

-Rob

Re: Row_based qvd optimized

hic — Thu, 17 Dec 2015 10:54:09 GMT

The new 'row-based qvd optimized' is the same as the old 'qvd optimized'. So, looking at the current situation, it was totally unnecessary to change this message.

However, for the future, the message may serve a purpose: We still haven't completely ruled out the possibility of a 'Column-based qvd optimized' load, which probably would be even faster than the current load. But due to backward compatibility challenges we need to think more about how to introduce this.

HIC

Re: Row_based qvd optimized

sunny_talwar — Thu, 17 Dec 2015 11:00:29 GMT

Thank you Henric Cronström‌ for your clarification on this topic.

Best,

Sunny