Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sun_dip08
New Contributor III

Direct Discovery Issue - low performance

Hi All,

I am working on direct discovery for an existing application. I have all the code in place (direct query) with

following variables.

SET DirectTableBoxListThreshold = 100000;

SET DirectConnectionMax=30;

The Teradata table is huge some 30Billion rows over which I am doing direct discovery query. After reload at the first time it gives me the good results but as I navigate and change the filter, the application goes on thinking and never produced a result.

Is it because a huge data set or I am missing something here (in list boxes)?  Also If I tried to close the application and open it on desktop - it's taking forever to open.

Please help. Or any other work around to handle this situation.

Any reply appreciated!

1 Solution

Accepted Solutions
sun_dip08
New Contributor III

Re: Direct Discovery Issue - low performance

It worked. Finally.

5 Replies
dimitri_obrant
Contributor

Re: Direct Discovery Issue - low performance

Hi,

you have to check the sql query, generated from QlikView. Direct Discovery generate some queries with WHERE ... IN () command from Dimension. If IN has many varchar values , sql server needs some time to replay. You can tray to change varchar dimension to integer.

How many dimensions do you have? If you don't need all full dimensions, you can change the dimensions to DETACH typ. Direct Discovery will be faster and sql queries are sympler. 

sun_dip08
New Contributor III

Re: Direct Discovery Issue - low performance

My SQL is :

SET DirectTableBoxListThreshold = 100000;

SET DirectConnectionMax=30;

ODBC CONNECT TO 'XXXX';

DIRECT QUERY

DIMENSION ACCT_KEY_NUM, PROD_KEY_NUM, DTE_KEY_NUM

MEASURE

  SELL_PRICE_DLR

FROM

  XX.YY_FACT ;

Noconcatenate

PROD_DIM:

Noconcatenate

Account_DIM:


Noconcatenate

TIME_DIM:



Which will give me a good data model.

How can I see the query generated by QV?

dimitri_obrant
Contributor

Re: Direct Discovery Issue - low performance


If you use MS SQL Server, you can see QlikView queries with SQL Server Profiler.

sun_dip08
New Contributor III

Re: Direct Discovery Issue - low performance

Got it working fine on my local. But when I try to put it on access point it gives me an error 'Database Connection failed'.

Not sure why?

Any Suggestions?

sun_dip08
New Contributor III

Re: Direct Discovery Issue - low performance

It worked. Finally.

Community Browser