slow connection time

[NuB]

I have a asp.net web application that connects to a database server that is
located outside of our building. When I run the web app the initial
connection to the database is slow ( around 30-35 seconds or so) but once I
connect the app runs quickly. Is there anyway to speed up the connection
time or am I stuck with it because its going across the "internet" to
connect to the offisite database location?

 

[Guest]

I have a asp.net web application that connects to a database server
that is located outside of our building. When I run the web app the
initial connection to the database is slow ( around 30-35 seconds or
so) but once I connect the app runs quickly. Is there anyway to speed
up the connection time or am I stuck with it because its going across
the "internet" to connect to the offisite database location?

This could be attributed to a couple factors - the initial load of the
application + database connect time.

Perhaps try connecting to a local test database, see if that speeds things
up. If it doesn't, then the delay is due to application load time.

If you want to reduce load time, you can try keeping your app alive:

http://authors.aspalliance.com/paulwilson/articles/?id=12

http://weblogs.asp.net/pwilson/archive/2003/12/02/40681.aspx