25:
167:
Local applications that need frequent access to databases can also benefit from connection pooling. Open connections can be maintained in local applications that do not need to service separate remote requests like application servers, but implementations of connection pooling can become complicated.
163:
without connection pooling open connections to database services as required and close them when the page is done servicing a particular request. Pages that use connection pooling, on the other hand, maintain open connections in a pool. When the page requires access to the database, it simply uses an
142:
application, is costly and wastes resources. In connection pooling, after a connection is created, it is placed in the pool and it is used again so that a new connection does not have to be established. If all the connections are being used, a new connection is made and is added to the pool.
137:
maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a database connection for each user, especially requests made to a dynamic
179:
Administrators can configure connection pools with restrictions on the numbers of minimum connections, maximum connections and idle connections to optimize the performance of pooling in specific problem contexts and in specific environments.
164:
existing connection from the pool, and establishes a new connection only if no pooled connections are available. This reduces the overhead associated with connecting to the database to service individual requests.
173:
89:
220:
247:
61:
263:
68:
108:
143:
Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database.
42:
75:
46:
57:
35:
152:
82:
122:
8:
189:
176:, simplifying the implementation of connection pools in database-intensive applications.
169:
134:
156:
216:
160:
210:
130:
257:
24:
139:
209:
Pugh, Eric; Gradecki, Joseph D. (11 November 2005).
49:. Unsourced material may be challenged and removed.
255:
208:
248:Properly Handling Pooled JDBC Connections
172:implement connection pooling and related
109:Learn how and when to remove this message
256:
215:. John Wiley & Sons. p. 65.
47:adding citations to reliable sources
18:
250:", blog post by Christopher Schultz
202:
13:
14:
275:
240:
23:
146:
34:needs additional citations for
159:to handle connection pooling.
1:
195:
16:Cache of database connections
7:
264:Database management systems
183:
10:
280:
153:enterprise applications
212:Professional Hibernate
168:A number of available
135:database connections
123:software engineering
43:improve this article
190:Object pool pattern
157:application server
222:978-0-7645-8951-5
174:SQL query pooling
161:Dynamic web pages
119:
118:
111:
93:
58:"Connection pool"
271:
234:
233:
231:
229:
206:
138:database-driven
114:
107:
103:
100:
94:
92:
51:
27:
19:
279:
278:
274:
273:
272:
270:
269:
268:
254:
253:
243:
238:
237:
227:
225:
223:
207:
203:
198:
186:
149:
127:connection pool
115:
104:
98:
95:
52:
50:
40:
28:
17:
12:
11:
5:
277:
267:
266:
252:
251:
242:
241:External links
239:
236:
235:
221:
200:
199:
197:
194:
193:
192:
185:
182:
151:Web-based and
148:
145:
117:
116:
31:
29:
22:
15:
9:
6:
4:
3:
2:
276:
265:
262:
261:
259:
249:
245:
244:
224:
218:
214:
213:
205:
201:
191:
188:
187:
181:
177:
175:
171:
165:
162:
158:
154:
144:
141:
136:
132:
128:
124:
113:
110:
102:
91:
88:
84:
81:
77:
74:
70:
67:
63:
60: –
59:
55:
54:Find sources:
48:
44:
38:
37:
32:This article
30:
26:
21:
20:
226:. Retrieved
211:
204:
178:
166:
150:
147:Applications
126:
120:
105:
99:October 2022
96:
86:
79:
72:
65:
53:
41:Please help
36:verification
33:
228:18 October
196:References
69:newspapers
170:libraries
258:Category
184:See also
155:use an
140:website
83:scholar
219:
85:
78:
71:
64:
56:
131:cache
129:is a
90:JSTOR
76:books
230:2022
217:ISBN
125:, a
62:news
133:of
121:In
45:by
260::
246:"
232:.
112:)
106:(
101:)
97:(
87:·
80:·
73:·
66:·
39:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.