Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What is sqlCacheDependency?

Posted on 2007-11-16
4
Medium Priority
?
508 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 1000 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 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

876 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