Обсуждение: jdbc connection pool settings
I'm in the process of implementing connection pooling and the setup I'm using (http://www.javaexchange.com - really slick!) has settings for min # connections and max # connection. Any suggestions on where I should set these values? min=2, max=6? My site will be outside the firewall, open to the public for all to trash. Culley __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
it depends on what kind of concurrent connections u will be getting.. For admin interfaces the kind of settingu mentioned might be OK but in case it is a heavily loaded site then u need to think.. Anand On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote: >I'm in the process of implementing connection pooling >and the setup I'm using (http://www.javaexchange.com - >really slick!) has settings for min # connections and >max # connection. Any suggestions on where I should >set these values? min=2, max=6? My site will be >outside the firewall, open to the public for all to >trash. > >Culley > >__________________________________________________ >Do You Yahoo!? >Get personalized email addresses from Yahoo! Mail - only $35 >a year! http://personal.mail.yahoo.com/
Quoting Culley Harrelson <culleyharrelson@yahoo.com>: > I'm in the process of implementing connection pooling > and the setup I'm using (http://www.javaexchange.com - > really slick!) has settings for min # connections and > max # connection. Any suggestions on where I should > set these values? min=2, max=6? My site will be > outside the firewall, open to the public for all to > trash. Although you're using JDBC here, this is actually a basic postgres admin problem. The size of your pool would be based on what resources you have available and how much traffic you're expecting. Peter > > Culley > > __________________________________________________ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/