5 Replies Latest reply: Aug 13, 2015 5:33 PM by Sandip Patekar RSS

    Direct Discovery Issue - low performance

    Sandip Patekar

      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!