Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

malome64
New Contributor

Load script Qlik Sense vs. Qlik View - speed

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?

Tags (2)
5 Replies
MVP
MVP

Re: Load script Qlik Sense vs. Qlik View - speed

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

Re: Load script Qlik Sense vs. Qlik View - speed

IS your QV local and QS on a remote server?

IS your qvd local to both apps?

malome64
New Contributor

Re: Load script Qlik Sense vs. Qlik View - speed

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

Both using same QVD from local drive.

malome64
New Contributor

Re: Load script Qlik Sense vs. Qlik View - speed

Thanks, but problem is not loading time.

The problem is a big difference between QV and QS.

Re: Load script Qlik Sense vs. Qlik View - speed

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