TConnectionPoolDescriptor configuration

Hi all,

I’d like to know if there’s a recommendation on how to tune the # of initial connections and max. connections. Also, I’d like to know the difference, from a performance point of view, of using this pool against creating a connection every time is needed. This second question arises because, at first sight, the way of hanling connections is very different between Tamino and a regular RDBMS (due to the underlaying nature of the connection’s state).

Kind regards,
Carlos

Hi Carlos,

We are looking for some help regarding that issue also. Your post is very old; have anybody come up with some help since then?

Our current settings are this:
TConnectionPoolDescriptor poolDescriptor = new TConnectionPoolDescriptor();
poolDescriptor.setDatabaseURI(url);
poolDescriptor.setPassword(“u”);
poolDescriptor.setPassword(“p”);
poolDescriptor.setInitConnections(2);
poolDescriptor.setMaxConnections(5);
poolDescriptor.setTimeOut(900);

Can we raise the setMaxConnections to for example 100? Without any impact on the performance?

Regards from Ole

interresearch a|s - Vestergade 9 - DK-1456 Copenhagen K
Phone: +45 70 27 28 72 - Mobile: +45 20 10 21 74 - Fax: 70 27 28 79
E-mail: oen@interresearch.dk - Homepage: www.interresearch.net

Hi Tamino,

Still no answer regarding this important issue…

Does anyone know where there is some documentation about this issue, so I can’t find the information myself? I haven’t been able to find any documentation…

Regards Ole