Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
p2bl
Yak Posting Veteran
54 Posts |
 Posted - 2002-02-17 : 05:06:38
|
| if I use ADO to connect to SQL Server,who handled the connection pool?MTS?IIS? or no connection pool?Must I start use connection pool in the ODBC console?Will it make my asp page connect to Sql server faster?I do not know what is what |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-17 : 05:14:32
|
| Connection pooling just holds connections to the server.If a connection is released by the application it is held open and the next connect using the same criteria reuses the connection from the pool. As making a new connection takes a lot of resources then the reuse of the connection will save time.There will be a timeout after which the connections will be terminated if not reused.MTS implements connection pooling and so can odbc. Also look at oledb session pooling (not available to VB).It can have a few effects on spid specific objects though.see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.aspandhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q169377.http://support.microsoft.com/default.aspx?scid=kb;en-us;Q164221==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy.Edited by - nr on 02/17/2002 05:26:29 |
 |
|
|
p2bl
Yak Posting Veteran
54 Posts |
Posted - 2002-02-19 : 05:23:47
|
| Thanks a lot!======================== ,-~~-.___. / | ' ( ) 0 \_/-, ,----' ==== / \-'~; / __/~| \/ =( _____| |
|
|
|
|
|
|
Connection pool?