[AccessD] fIRST TIME ACCESS TO SQL SERVER

John,

  Your probably seeing connection pooling at work.  For SQL Server, it's on
by default and the timeout is 5 minutes.

  In terms of processing a query, one of the tasks with the most overhead is
contacting the SQL Server.  Connection pooling helps with that by
maintaining a connection to the server, but marking that connection as
"available" for use.  After the timeout, it closes the connection.

  You can turn pooling on/off and adjust the timeout through the ODBC Data
manager in Admin tools.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 25, 2010 3:13 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] fIRST TIME ACCESS TO SQL SERVER

I am using ODBC to link to sql server views from Access 2003.  The very
first view I open causes a 
delay of several seconds.  After that none of the views have a delay.  I
think (and will report back 
later) that after a time of inactivity I encounter that delay again.

Is there something I can do to prevent that opening delay? (I suspect not).

Is there something I can do to prevent the "timeout" or whatever is
occurring that causes the delay 
to be encountered again later?  (I suspect so).

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com