2 Replies Latest reply on Jun 28, 2013 9:17 AM by Steven Hawkins

    Teiid Performance when query large amount of data

    Neeta L Newbie

      Hello All,

       

      I have done following things in Teiid designer

      - created source model from SQL Server DB (import)

      - created view model

      - created 2 virtual procedures Proc1 and Proc2 to retrieve data based on our business log (proc1 calls proc2)

      - VDB with both source model and view model

      - created Java client code to connect to VDB and call proc1 to retieve huge data. (Using connection, resultset and SOP(resultset.getString method)

       

      => But after sometime, console gets hang.I waited for almost an hr, but it did not get complete and then I stopped it.

       

      I have around 99,999 records

       

      Please let me know what can I do to improve the performance

       

      Thanks,

      Neeta