Archives of the TeradataForum

Message Posted: Tue, 07 Feb 2005 @ 23:23:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Try searching for "Connection pool" on the web. There is plenty of information on the topic.

In a nutshell, a Connection pool holds a number of database sessions which applications or processes borrow.

One advantage is that a large number of users can share a smaller number of sessions (eg. more users than the database could directly support).

Another advantage is that the process of borrowing a session is typically much faster than establishing a brand new session (i.e. improved performance).

	<Prev	Next>		<<First	<Prev	Next>	Last>>