1 Reply Latest reply on Apr 1, 2016 10:39 AM by Ramesh Reddy

    Number of data source connections on teiid.

    Nishant Agrawal Novice

      Hi Ramesh ,

       

      is there any max limit of datasource connection we can create on teiid ? or from where we can specify the limit ?


      In standalone-teiid.xml  ,


                  <thread-pools>

                      <thread-pool name="default">

                          <max-threads count="10"/>

                          <keepalive-time time="100" unit="milliseconds"/>

                      </thread-pool>

                  </thread-pools>

       

       

      does max-thread count indicate at one moment only 10 data sources connections will be active like 1 thread for 1 data source?

       



      Thanks

        • 1. Re: Number of data source connections on teiid.
          Ramesh Reddy Master

          No, the fragment of XML you showed above is number threads in JBoss EAP, those do not correlate to the number of data sources. Each data source configuration, under "data sources" subsystem where you define the URL, username, password etc, you can also define the min and max number connections to the source database you create in that connection pool. Here you define as many you want, obviously you need to be aware about what is feasible for the given VM and your environment. Saying I want 2000 connections when your Oracle instance only supports or capable of 200 is not going to help.

           

          As per how many connections that Teiid uses is dictated by Teiid query plan based on the query. Typically it is one connection per datasource/query, and possibly one thread for datasource and one for processing. But both connections and threads are returned to pool when they are idle are free.

           

          Ramesh..