topic Sql queries with UNION ALL in QlikView

Sql queries with UNION ALL

Josn_Qlik356 — Sat, 16 Nov 2024 17:51:30 GMT

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

Re: Sql queries with UNION ALL

chrismarlow — Sun, 08 Nov 2020 14:32:38 GMT

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.

Re: Sql queries with UNION ALL

Kushal_Chawda — Sun, 08 Nov 2020 15:54:19 GMT

@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.