SQL Code running faster on QLIKVIEW than SQL Manegement Studio

MarvinGomes — Fri, 02 Apr 2021 08:42:10 GMT

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!

Re: SQL Code running faster on QLIKVIEW than SQL Manegement Studio

marcus_sommer — Mon, 21 Oct 2019 13:27:03 GMT

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

topic Re: SQL Code running faster on QLIKVIEW than SQL Manegement Studio in Connectivity & Data Prep

SQL Code running faster on QLIKVIEW than SQL Manegement Studio

Re: SQL Code running faster on QLIKVIEW than SQL Manegement Studio