Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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.
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.
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
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....
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
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.