Sql queries with UNION ALL

[Josn_Qlik356]

Hi All,

i have SQL 8 sql queries  and used union all to concatenate all .its taking 2.5 hours to create qvd.

can any one suggest me the best approach to improve the load time by replacing the queries with Qlikview data model.

Example data :

Sql duery1

unionall

sql query 2

union all

sql query 3

Union all

----

Sql query 8;

Thanks IN advance,

Jason

[chrismarlow]

Hi,

I think you are going to need to work with the folks on the database side here to work out what is the most efficient way of doing this.

It might be that they could create something that simplifies what you are pulling back, it might be that even if you broke it down on the QlikView side it would still take 2.5 hours to pull down and reconnect the data in Qlik.

Sorry if this does not seem very helpful.

Cheers,

Chris.

[Kushal_Chawda · Accepted solution]

@Josn_Qlik356 

Best way would be to create a single table out of 8 sql query at database level itself. Your database team can help you to create that table. Then you can extract only single table within Qlik.

If above not possible due to database constraints, you can create multiple qvw files for single query to run all applications in parallel. So in your case you would need to create 8 qvw apps for individual query creating individual qvds which you can run in parallel.  Then you can create multiple apps finish trigger to run the final application (you can  use *.qvd in final application to load individual query qvd). If you don't want to create 8 applications , you can further reduce the application by creating 4 application which can run two union queries.