Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
caiogil1
New Contributor III

Load from QVD x XSLX x QVF (Binary Load)

Hello guys,

I have a question about how Qlik Sense works (performance) in these 3 situations.

1 - Load the data from a QVD

2 - Load the data from a file (XSLX for example)

3 - Load the data from a qvf (Binary load)

Its clear that the load time between QVD file and XSLX file is very different. But my doubt it is about when the data is already loaded in an Qlik Sense Application (QVF), there is any difference in the performance when loading an object (Chart/Table) in these 3 situations? There is one of them that makes the object load the data faster than other?

1 Solution

Accepted Solutions
Partner
Partner

Re: Load from QVD x XSLX x QVF (Binary Load)

Hi Caio,

If you have the exact same data on three situations and the same object chart with same expression (in so, having all the same).

I don't see why the chart would calculate faster in any of the 3 cenarios.

What would change is how the data is loaded (and I'm assuming the QVD and Binary would load the data faster).

Since it's all in memory, the calculation would not differ in my opinion.

Felipe.

2 Replies
Partner
Partner

Re: Load from QVD x XSLX x QVF (Binary Load)

Hi Caio,

If you have the exact same data on three situations and the same object chart with same expression (in so, having all the same).

I don't see why the chart would calculate faster in any of the 3 cenarios.

What would change is how the data is loaded (and I'm assuming the QVD and Binary would load the data faster).

Since it's all in memory, the calculation would not differ in my opinion.

Felipe.

balabhaskarqlik
Honored Contributor

Re: Load from QVD x XSLX x QVF (Binary Load)

There is NO difference in the performance when loading an object (Chart/Table) in these 3 situations. Because data processed, data model created & data loaded into in-memory.

And you're not using different expressions in 3 scenarios, those are same.