Load script Qlik Sense vs. Qlik View - speed

[malome64]

I have on same machine

• Qlik Sense Enterprise June 2017 Patch 1
• Qlik View Desktop 11.20 SR12 64-bit

I run only simple script

TMP:

LOAD

  Min(Date) as MinDate

FROM [test.qvd] (qvd);

where test.qvd has over 26 mil. records.

Load time Qlik Sense 5:15 min

Load time Qlik View  1:12 min.

Why? Why Qlik Sense is 4 times slower?

Can anyone explain it to me?

[sunny_talwar]

Not really sure I know why there is difference in loading times, but look at a faster way to load Max(date)

“Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook

[robert_mika]

IS your QV local and QS on a remote server?

IS your qvd local to both apps?

[malome64]

QV and QS on same hard drive, on same server.

Both using same QVD from local drive.

[malome64]

Thanks, but problem is not loading time.

The problem is a big difference between QV and QS.

[kaushiknsolanki]

Hi,

It may be because Qlik Sense server is configured by default to create a "Search Index" while script is reloaded.

This makes script run little longer then usual time.

You can uncheck this option from Engine setting from QMC.

And after doing this try reload and see the difference.

Regards,

Kaushik Solanki