Solved

What is sqlCacheDependency?

Posted on 2007-11-16
4
498 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

708 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

14 Experts available now in Live!

Get 1:1 Help Now