SQL Code running faster on QLIKVIEW than SQL Manegement Studio

[MarvinGomes]

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!

[marcus_sommer]

Qlik doesn't execute any sql else it transfers it to the database and received just the results. Therefore it depends entirely to the performance of the db/driver/network how fast a query will be.

Beside this applying a filter to a query could increase the run-times more as just returning all data.

- Marcus