Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

A query seems to take a tenth of the time to run in sql server compared to when it runs in QV. (3 minutes vs 3 hours)

A query seems to take a tenth of the time to run in sql server compared to when it runs in QV... (3 minutes vs 3 hours)

anyone experiencing the same?

I am not able to find the explanation...

7 Replies
marcus_sommer

The reason will be the driver and/or the network then the query itself will be executed from sql server. That meant the transfer to qv delayed the matter.

- Marcus

PradeepReddy
Specialist II
Specialist II

As mentioned by Marcus, Network bandwidth also matters...

Are you  performing any complex calculations & aggregations, if so it will take time...

IF you are doing a plain unload, it won't take that much time.

dominicmander
Partner - Creator
Partner - Creator

Yes, Assuming you are using the same query in both the database and your load statement in Qlik then this will be due to the time required to transfer the result over the network to Qlik, not due to the time taken to perform the query.

One possible solution might be to load the original tables from the database into Qlik first, and then perform the joins etc in your current query in Qlik itself. Often, the original tables will be much smaller than the result of a joined query, so the volume of data to be transferred over the network is smaller, so the end-to-end reload time will be shorter.

marcus_sommer

In addition to the suggestion from DominicMander is to use incremental approaches. Here you find various links to these topic: Advanced topics for creating a qlik datamodel

- Marcus

Anonymous
Not applicable
Author

Hi guys, thanks for taking the time... Problem is,  that it used to work from QV perfectly last month... It is since a couple of weeks that it is taking long....

marcus_sommer

Then you could try to find out if anything in your environment has changed - maybe some new security measures and the network-traffic will be routed through a proxy or ...

- Marcus

maxgro
MVP
MVP

Try the same query from another pc (or server) with a different tool (not Qlik), for sql server it could be Sql Server Management Studio; then compare the time.