I am concerned about performance. Usually, in a situation where I am
not using a global.asa (shared host, etc), I explicitly close the
connection at the bottom of the page in a footer, eg: conn.Close set
conn = nothing

Now, I am working with a global.asa file, and the following:
sub Application_OnStart
conString = "driver={sql server}......"
Application("conString")=conString
set Conn = Server.CreateObject("ADODB.Connection")
conn.Open conString
set Application("conn")=conn
end sub

I am concerned about performance. Usually, in a situation where I am not using a global.asa (shared host, etc), I explicitly close the connection at the bottom of the page in a footer, eg: conn.Close set conn = nothing

Now, I am working with a global.asa file, and the following: sub Application_OnStart conString = "driver={sql server}......" Application("conString")=conString set Conn = Server.CreateObject("ADODB.Connection") conn.Open conString set Application("conn")=conn

:-) You haven't been paying attention, have you?
It is a bad idea to store an apartment-threaded COM object, such as an ADO
connection object, in Application or Session.http://www.aspfaq.com/show.asp?id=2053

Store the connection string in Application. Use it in each page (use an
include file) to open a connection in the page. ADO Session pooling
(http://msdn.microsoft.com/library/en...l/pooling2.asp) will keep
the number of connections opened to a minimum, as well as minimizing the
time used to create the connections on each page. Close and destroy the
connection on each page as soon as you are finished with it, allowing it to
go back into the pool for the next page to use.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

I am concerned about performance. Usually, in a situation where I am not using a global.asa (shared host, etc), I explicitly close the connection at the bottom of the page in a footer, eg: conn.Close set conn = nothing

Now, I am working with a global.asa file, and the following: sub Application_OnStart conString = "driver={sql server}......" Application("conString")=conString set Conn = Server.CreateObject("ADODB.Connection") conn.Open conString set Application("conn")=conn end sub

I am concerned about performance. Usually, in a situation where I am not using a global.asa (shared host, etc), I explicitly close the connection at the bottom of the page in a footer, eg: conn.Close set conn = nothing

Now, I am working with a global.asa file, and the following: sub Application_OnStart conString = "driver={sql server}......" Application("conString")=conString set Conn = Server.CreateObject("ADODB.Connection") conn.Open conString set Application("conn")=conn :-) You haven't been paying attention, have you?

Oh, contrair, mon ami! I have definately been paying attention, hence
the question.
It is a bad idea to store an apartment-threaded COM object, such as an ADO connection object, in Application or Session.http://www.aspfaq.com/show.asp?id=2053

Store the connection string in Application. Use it in each page (use an include file) to open a connection in the page. ADO Session pooling (http://msdn.microsoft.com/library/en...l/pooling2.asp) will keep the number of connections opened to a minimum, as well as minimizing the time used to create the connections on each page. Close and destroy the connection on each page as soon as you are finished with it, allowing it to go back into the pool for the next page to use.

I am concerned about performance. Usually, in a situation where I am not using a global.asa (shared host, etc), I explicitly close the connection at the bottom of the page in a footer, eg: conn.Close set conn = nothing

Now, I am working with a global.asa file, and the following: sub Application_OnStart conString = "driver={sql server}......" Application("conString")=conString set Conn = Server.CreateObject("ADODB.Connection") conn.Open conString set Application("conn")=conn end sub