Database connection: Difference between revisions

Content deleted Content added
Pooling: Pooling is not the same thing as multiplexing. Multiplexing implies concurrent usage of a single connection. Pooling is simple reuse.
Add link to wikipedia page on 'blocking' in computing.
Line 27:
In a [[Client–server model|client–server architecture]], on the other hand, a persistent connection is typically used so that server state can be managed. This "state" includes server-side [[Cursor (databases)|cursors]], {{clarify span|temporary products|date=September 2012}}, connection-specific functional settings, and so on.
 
It is desirable to set some limit on the number of connections in the pool. Using too many connections may just cause [[thrashing (computer science)|thrashing]] rather than get more useful work done. In case an operation is attempted and all connections are in use, the operation can [[Blocking (computing)|block]] until a connection is returned to the pool, or an error may be returned.
 
== See also ==