|
|
|
|
|
Total Hits: 151 | Today: 0
|
Author: cwebbbi.spaces.live
|
Rating:
|
|
Cache-warming is one of the most neglected performance-tuning techniques for Analysis Services: perhaps it seems too much like cheating? Yet almost everyone knows how much difference there can be executing a query on a cold cache and a warm cache so there should be no excuse not to be doing it, especially if you know what queries your users are likely to be running in advance. AS2005's caching mechanism is more complex than I can describe here (or than I can describe full stop - although I hear ...
|
|
|
|
Total Hits: 110 | Today: 0
|
Author: Donny Mack
|
Rating:
|
|
The ASP.NET Cache supports invalidation based on key, timestamp, or file dependencies, e.g. file changes and the cache item is invalidated. A frequent question is how to support this from a database, e.g. we're caching a DataSet, or some other reperesentation of data, in the ASP.NET Cache and the table(s) representing that data changes; thus the data in the Cache is no longer valid. This sample shows using some simple code that will automatically wire up a trigger on a table and call an extended...
|
|
|
|
Total Hits: 130 | Today: 0
|
Author: Donny Mack
|
Rating:
|
|
We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...
|
|
|
|
Total Hits: 147 | Today: 0
|
Author: Charles Carroll
|
Rating:
|
|
To make applications faster and provide an added benefit to using UtilityBelt all functions internally use DataTables to fetch data from the database support caching in an easy transparent fashion by setting properties instead of changing the actual library calls....
|
|
|
|
Total Hits: 317 | Today: 0
|
Author: Tom Pullen
|
Rating:
|
|
One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memory to use, whether to dynamically allocate it, and so on. Otherwise, there isn’t a lot you can do in terms of memory tuning. But you may well find yourself in a situation where you want to know what tables and ind...
|
|
|
|
Total Hits: 64 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
There are many tools available for managing databases, exploring and modifying schemas, and writing and executing queries. One such off-the-shelf tool worth investigating is DatabaseSpy 2007 by Altova. DatabaseSpy can connect to a wide variety of different data stores—Microsoft® Access®, Microsoft SQL Server™, Oracle, MySQL, Sybase, and so on—and provides a uniform user experience regardless of the database.
When first connecting to a database through DatabaseSpy, a new project is automat...
|
|
|
|
Total Hits: 131 | Today: 0
|
Author: Luke Stratman
|
Rating:
|
|
Luke Stratman shows how and why to use the SqlCacheDependency class.
It's hard for me to pin down a favorite feature in the 2.0 version of the .NET framework. Is it generics? Or maybe built-in configuration file encryption? How about the updated configuration classes? It's a tough choice. But there's no doubt about my favorite example of what makes .NET 2.0 such a compelling development platform: the SqlCacheDependency class. It does a brilliant job of illustrating just how well the vario...
|
|
|
|
Total Hits: 142 | Today: 0
|
Author: Iqbal M Khan.
|
Rating:
|
|
NCache lets you cache data closer to your application in the middle-tier so you can reduce expensive trips to the database. This in turns significantly speeds up your application. It also makes it more scalable because the load on your database is reduced allowing it to handle a larger number of clients without any hardware upgrades.
However, when you cache data, you're actually creating a copy of it outside of your database. This introduces the risk that data in your database would be mo...
|
|
|
|
Total Hits: 170 | Today: 0
|
Author: William Pearson
|
Rating:
|
|
This article is a member of the series MSSQL Server Reporting Services. The series is designed to introduce MSSQL Server Reporting Services (“Reporting Services”), presenting an overview of its features, with tips and techniques for real-world use. For more information on the series in general, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting. For the software components, samples and tools needed to complete the hands-on portion of this article, see BlackBe...
|
|
|
|
Total Hits: 108 | Today: 0
|
Author: Irena Kennedy
|
Rating:
|
|
It’s well known that, to improve performance, SQL Server caches query execution plans in memory. But would you like to know what query execution plans are currently in the cache?...
|
|
|
|
Total Hits: 226 | Today: 0
|
Author: Marco Bellinaso
|
Rating:
|
|
In every site or web-based application there is some data that doesn’t change very often, which is requested very frequently by a lot of end users. Examples are the list of article categories, or the e-store’s product categories and product items, the list of countries and states, and so on. The most common solution to increase the performance of your site is to implement a caching system for that type of data, so that once the data is retrieved from the data store once, it will be kept in memor...
|
|
|
|
Total Hits: 240 | Today: 0
|
Author: asp.net
|
Rating:
|
|
SQL Express dependency caching is easier to set up because SQL Express natively supports change notifications. You do not need to run special command line utilities to prepare the database because notifications are automatically generated by SQL Express. Moreover, the SqlCommand class inherently supports dependency caching. Simply instantiate the SqlCacheDependency class with a SqlCommand object and then use the Response object's AddCacheDependency method to add the SqlCacheDependency object to ...
|
|
|
|
Total Hits: 200 | Today: 0
|
Author: Peter Bromberg
|
Rating:
|
|
How to create a Sitemap from a database table with the SqlSitemapProvider and use it to populate your web site's TreeView Navigation Control, with SqlCacheDependency built in....
|
|
|
|
Total Hits: 145 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
The simplest caching strategy is to allow cached data to expire after a specified period of time. But this simple approach means that the cached data maintains no association with its underlying data source, resulting in stale data that is held too long or current data that is expired too soon. A better approach is to use the SqlCacheDependency class so that data remains cached until its underlying data has been modified in the SQL database. This tutorial shows you how....
|
|
|
|
Total Hits: 101 | Today: 0
|
Author: Donny Mack
|
Rating:
|
|
We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...
|
|
|
|
Total Hits: 199 | Today: 0
|
Author: asp.net
|
Rating:
|
|
SQL Server 7/2000 dependency caching requires you to run some setup scripts that build the cache tables ASP.NET will monitor for changes. For this purpose the .NET Framework 2.0 provides a utility called aspnet_regsql.exe.
You do not need to have SQL Server 7/2000 installed in order to follow these steps. The same scripts and legacy dependency caching implementation (next lesson) will work with SQL Express....
|
|
|
|
Total Hits: 317 | Today: 0
|
Author: Wei-Meng Lee
|
Rating:
|
|
Caching has long been recognized as one of the more effective ways to improve your ASP.NET web applications. However, one particular caching feature that was dearly missing in ASP.NET 1.x was SQL cache dependency. SQL cache dependency is the ability to invalidate a database cache if data in a table is changed. In ASP.NET 2.0, Microsoft has, much to the joy of developers, added the new SQL cache dependency feature. In this article, I will discuss SQL cache dependency in ASP.NET 2.0, as well as di...
|
|
|
|
Total Hits: 177 | Today: 0
|
Author: ExtremeExperts.com
|
Rating:
|
|
This topic has been in my minds for quite some time now. Just thought to get them into a understandable article for public use ... Well, most of the DBA's and many programmers of SQL Server should have heard of the terms data cahe and procedure cahe in conjunction with SQL Server. These are the primary building blocks or parts of the caching mechanism we all talk about. But what is this cache on first place?...
|
|
|
|
Total Hits: 107 | Today: 1
|
Author: Scott Mitchell
|
Rating:
|
|
As developers creating data-driven Web applications, we've all written more than our fair share of SQL statements. If I had a nickel for every SELECT statement or UPDATE statement I've written in my six years as a Web developer, I'd be a rich man. Despite the familiarity with SQL that many Web developers have, one of the lesser known SQL tools is the CASE statement. The CASE statement is a wily little fellow that can be added to both the SELECT portion of a SELECT statement as well as the ORDER ...
|
|
|
|
Total Hits: 165 | Today: 0
|
Author: William Pearson
|
Rating:
|
|
This article is a member of the series MSSQL Server Reporting Services. The series is designed to introduce MSSQL Server Reporting Services (“Reporting Services”), presenting an overview of its features, with tips and techniques for real-world use. For more information on the series in general, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting. For the software components, samples and tools needed to complete the hands-on portion of this article, see BlackBe...
|
|
|
|
|
|
