NCache 3.1 provides cache synchronization with database:

sarah

Member
Joined
Mar 15, 2006
Messages
10
Programming Experience
Beginner
Article-Object Query Language for Distributed Cache

Author: Iqbal M. Khan works for Alachisoft, a leading software company providing NCache, a clustered object cache for .NET, and TierDeveloper, an O/R Mapping code generator for .NET. You can reach him at iqbal@alachisoft.com or visit Alachisoft at www.alachisoft.com.

Object Query Language for Distributed Cache:

NCache lets you create a scalable distributed cache in the middle-tier so you can reduce expensive trips to the database and greatly improve your application performance. It also improves application scalability because you are able to find frequently used data in this highly scalable cache instead of a single database server that cannot scale up very well.

Your application typically uses a cache as a Hashtable where everything is stored based on a key and you must have this key to fetch an item. This is like having a relational database where you can only use primary key to find data. This works fine in many situations but in a real life complex application your application often needs to find data based on attributes other than the primary key. And, since you're keeping a lot of your data in the cache, it would be very useful if you could search the cache in this manner as well. NCache provides exactly such facility.

For more read: http://www.alachisoft.com/rp.php?so...coim&dest=/articles/cache_parallel_query.html
For Download Ncache 3.1:
http://www.alachisoft.com/rp.php?source=/vbdotnetforums.com./&dest=/download.html
 
Alachisoft has released NCache 3.1, a high performance distributed object cache for mission critical .NET and Java applications with real-time data access needs. Reduce expensive database trips by caching data close to your application. Use a distributed cache in a multi server environment from web, N-Tier, or distributed/grid applications.

NCache now provides full support for synchronizing your distributed cache with your database. NCache uses .NET events for synchronization with SQL Server 2005 and polling for SQL Server 2000, Oracle, Sybase, and all other databases accessible through OLEDB.

For SQL Server 2005, whenever data changes in the database, SQL Server fires a .NET event and NCache catches it and then either removes the corresponding item from the cache or reloads it from the database.

And, for other databases, NCache polls a specific table in the database where your modified triggers update information about data changes. Then, if any cached item has been changed in the database, NCache detects it through polling and either removes it from the cache or reloads it from the database.

Read more about NCache 3.1
http://www.alachisoft.com/rp.php?source=/vbdotnetforums.com.news7/&dest=/ncache/index.html

Download NCache 3.1
http://www.alachisoft.com/rp.php?source=/vbdotnetforums.com.news7/&dest=/download.html
 
Back
Top