Solved

What is sqlCacheDependency?

Posted on 2007-11-16
4
499 Views
Last Modified: 2008-02-01
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

0
Comment
Question by:John Account
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
hismightiness earned 250 total points
ID: 20300266
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
 
LVL 9

Expert Comment

by:hismightiness
ID: 20300275
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
 
LVL 17

Assisted Solution

by:ZeonFlash
ZeonFlash earned 250 total points
ID: 20300281
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
 

Author Comment

by:John Account
ID: 20300888
Thanks, guys. I appreciate it very much!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now