SQL Code running faster on QLIKVIEW than SQL Manegement Studio

[rashimkavel7]

Hey everybody, I just recently started using Qlikview because my database went north from 1M rows.

So, my query took 9 hours to complete using SQL management studio 2014 express for only 1.3M rows. When I put it on qliview I expanded it to all my products going shy of 4.5M.

My Qlikview code is simply the connection to my server and then a SQL statement followed by my exact same code I use on SQL MS.

Thing is, I thought it would take forever but it took only half an hour. I already checked some of the data and it seems to be working just right but something seems odd.

Why would it be faster? does it make any sense? Can I trust my data?

Thanks in advance!

[Brett_Bleess]

I would recommend turning on the Script logging to check the number of rows fetched etc., at least that way you can confirm that part of things.

Script Logging 

The only other idea would be to use RecNo() or RowNo() functions to count things that way:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Count...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Count...

Regards,
Brett

[cwolf]

In contrast to SQL Management Studio, QlikView has an optimized memory management for large amounts of data and that starts with the loading of data. SQL Management Studio is in no way designed to handle large amounts of data. Accordingly, QlikView has to be many times faster.