|
 |
asp_database_setup thread: Connection pooling
Message #1 by "simon ryan" <sjr100@c...> on Fri, 25 May 2001 11:56:58
|
|
does anybody now if conection pooling still works if you cache a copy of
the connection object at session level then open and close it on each page.
Or is anyone aware of any other issues or implications of doing this?
DBMS is Oracle.
Thanks in advance for any contribution
Message #2 by Hal Levy <hal.levy@s...> on Fri, 25 May 2001 09:55:35 -0400
|
|
_NEVER_ use a connection object on the session level.
_NEVER_ use a connection object on the Application level.
_BETTER_ open a connection object right before you need it on a page and
destroy it as soon as you are done with it.
_BEST_ Do no dB access from ASP. Write COM objects to do your data access.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: simon ryan [mailto:sjr100@c...]
Sent: Friday, May 25, 2001 7:57 AM
To: ASP Database Setup
Subject: [asp_database_setup] Connection pooling
does anybody now if conection pooling still works if you cache a copy of
the connection object at session level then open and close it on each page.
Or is anyone aware of any other issues or implications of doing this?
DBMS is Oracle.
Thanks in advance for any contribution
Message #3 by "Cole, R. MR DOIM" <8r8251@e...> on Thu, 31 May 2001 08:02:10 -0400
|
|
Suppose you're using a temp table in Sybase to store intermediate results
between ASP pages? When the connection drops the temp table is dropped as
well. Anybody got any ideas?
Rich Cole
Signal Corporation
-----Original Message-----
From: Hal Levy [mailto:hal.levy@s...]
Sent: Friday, May 25, 2001 9:56 AM
To: ASP Database Setup
Subject: [asp_database_setup] RE: Connection pooling
_NEVER_ use a connection object on the session level.
_NEVER_ use a connection object on the Application level.
_BETTER_ open a connection object right before you need it on a page and
destroy it as soon as you are done with it.
_BEST_ Do no dB access from ASP. Write COM objects to do your data access.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: simon ryan [mailto:sjr100@c...]
Sent: Friday, May 25, 2001 7:57 AM
To: ASP Database Setup
Subject: [asp_database_setup] Connection pooling
does anybody now if conection pooling still works if you cache a copy of
the connection object at session level then open and close it on each page.
Or is anyone aware of any other issues or implications of doing this?
DBMS is Oracle.
Thanks in advance for any contribution
|
|
|
View Cart
