SQL Code running faster on QLIKVIEW than SQL Manegement Studio

[JohnsonGomes]

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!

[jonathandienst]

SQL MS connects to the database similarly to Qikview and queries from either source are executed on the SQL Server machine. So the possible differences (assuming the queries are the same) could be a network issue (eg SQL MS on your workstation, Qlikview in the server farm) or a different (OLEDB or ODBC) provider, possibly faulty or corrupted.

The numbers you supplied imply that it ot a simple network issue, so i would consider re-installing SQL MS.