topic Re: Sub Query Taking long time in QlikView in QlikView

Sub Query Taking long time in QlikView

Thu, 04 Apr 2013 10:41:12 GMT

Hi,

We are using a query to fetch the data from oracle database (around 90,000 records are there). The query contains 7 sub query. If we execute the query directly in TOAD it takes only 50 seconds. But when executing the same from QlikView it is taking 4 hours. Please could you advise the options to optimize this. Or is there any limitation in using sub queries in the QlikView.

We are using QlikView 10 SR4.

Thanks,

Sijo Joseph

Re: Sub Query Taking long time in QlikView

Thu, 04 Apr 2013 11:35:09 GMT

Hello Sijo,

We must avoid using sub-queries since they are not that performance oriented. As far as qlikview is concerned, as per my understanding, the QlikView lets the database engine take its time to run query and then use the result set.

Are you doing any aggregations on the result set as well? That might make it slow.

Also you can load individual tables in QlikView and then create a data model as required in using the sub-queries. Things can be made fast through scripting.

Thanks,

angad

Re: Sub Query Taking long time in QlikView

Thu, 04 Apr 2013 12:39:11 GMT

Thanks for the details

We are uding ORACLE OLEDB. in the last 3 months 45,000 records has been added and then the issue has started. Please can you advise.

Thanks,

Sijo