I am working on direct discovery for an existing application. I have all the code in place (direct query) with
SET DirectTableBoxListThreshold = 100000;
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.
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.