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