Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have on same machine
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?
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
IS your QV local and QS on a remote server?
IS your qvd local to both apps?
QV and QS on same hard drive, on same server.
Both using same QVD from local drive.
Thanks, but problem is not loading time.
The problem is a big difference between QV and QS.
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