SQL Code running faster on QLIKVIEW than SQL Manegement Studio
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?
QlikView doesn't execute any SQL else it transferred the statement per driver to the database and just received on the way back the resulting dataset. Therefore no from QlikView triggered query could be faster as within the database itself.
If you now experienced a significantly speed up in the performance it could mean that not all data comes back (the driver might not be able to handle certain expressions, datatypes, ... and skip them whereby more likely would be any error). Further thinkable is that one query is read-only and the other might be waiting to get access for locked records. Probably some reasons more but I think the bottleneck is the management studio ...
