2 Replies Latest reply on Jun 28, 2011 2:14 AM by Sabina Norderhaug

    row prefetch with Teiid ?

    Sabina Norderhaug Newbie

      One of the features of jdbc performance for Oracle is the ability to set row prefetch at application level - http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/oraperf.htm#i1043756

      Is there way to achive it while working with Teiid?


      Thank you.

        • 1. Re: row prefetch with Teiid ?
          Ramesh Reddy Master

          Teiid does not retrive results one row at a time, it has default fetch size of 512. I am not sure how this was different from JDBC API's fetch size property. Can you explain the difference? The link also has


          "Do not mix the JDBC 2.0 fetch size application programming interface (API) and the Oracle row-prefetching API in your application. You can use one or the other, but not both."



          • 2. Re: row prefetch with Teiid ?
            Sabina Norderhaug Newbie

            Thank you for your reply Ramesh.

            Oracle supports its own pre-fetch as well as standard jdbc prefetch, so i was asking if there is something similar with Teiid.

            But as you already mentioned there is always a way to control it with standard jdbc api.