topic Re: Direct Discovery Issue - low performance in QlikView

Direct Discovery Issue - low performance

Anonymous — Mon, 10 Aug 2015 21:49:40 GMT

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!

Re: Direct Discovery Issue - low performance

Anonymous — Tue, 11 Aug 2015 11:35:09 GMT

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.

Re: Direct Discovery Issue - low performance

Anonymous — Tue, 11 Aug 2015 15:33:18 GMT

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?

Re: Direct Discovery Issue - low performance

Anonymous — Wed, 12 Aug 2015 07:04:21 GMT

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

Re: Direct Discovery Issue - low performance

Anonymous — Thu, 13 Aug 2015 21:21:21 GMT

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?

Re: Direct Discovery Issue - low performance

Anonymous — Thu, 13 Aug 2015 21:33:34 GMT

It worked. Finally.