What is sqlCacheDependency?

Can anyone tell me what this block of code below means? What it's used for? Why have it there?

Thanks!
<caching>
	<sqlCacheDependency enabled="true" pollTime="1000">
		<databases>
			<add name="Pubs" connectionStringName="Pubs"/>
		</databases>
	</sqlCacheDependency>
</caching>

Open in new window

John AccountAsked:
Who is Participating?
 
hismightinessConnect With a Mentor Commented:
That sections allows ASP.Net to work in conjunction with the SQL Server to provide caching of data on-the-fly.  This results in a faster application for the end-user, but more processing time on the server.
0
 
hismightinessCommented:
To be more specific, the data in the location specified in the Pubs connection string is cached for 1000 seconds, and this dependency is enabled right now.
0
 
ZeonFlashConnect With a Mentor Commented:
It basically watches the database to see if there are any changes made, and if so, invalidates the cache.

http://dotnetslackers.com/articles/sql/TheSqlCacheDependencyClass.aspx
0
 
John AccountAuthor Commented:
Thanks, guys. I appreciate it very much!
0
All Courses

From novice to tech pro — start learning today.