数据缓存和SQL缓存依赖关系的差异 [英] Differences of Data Caching and SQL Cache dependancy

问题描述

我想了解几件事-数据缓存和SQL缓存依赖项之间有什么区别.

我们在上一个项目中实现了SQL Cache依赖关系，但由于上述原因，不得不中止了它，因为由于通知，某些事务非常缓慢.
目前，我正在为我的客户设计一个框架，并且已经实现了数据缓存.

此功能的问题在于，当前我正在单个Web服务器上进行POC，但是必须将应用程序部署在适当的多服务器环境(可能是Web场)上.如果我正在使用数据缓存，那么它将无济于事，因为多个用户将访问同一缓存，并且如果缓存无效，那么某些用户的数据将不一致.一种方法是为每个用户将SessionID(UserID)与Cache对象一起附加，但是如果您有更多的并发用户，那么我建议不要使用此功能，因为服务器会变得很繁琐.

我读了一篇有关Velocity的文章，但无法将其用于POC.

请提示.

在此先谢谢您.

There are a few things that I would like to know - What are the differences of Data Caching and SQL Cache dependancy.

We had implemented the SQL Cache dependancy in our last project but had to discontinue it due to the reasons mentioned above as due to notifications some of the transactions were very slow.
Currently I am designing a framework for my client and I have implemented Data caching.

The problem with this feature is that, currently I am doing a POC on a single Web Server, but the application has to be deployed on the proper multi server environment (maybe web farm). If I am using Data caching then it doesnt help as multiple users would access the same cache, and if cache is invalidated, then the data would be inconsistent for some users. One approach is attaching the SessionID (UserID) with the Cache object for each user, but then if you have more number of concurrent users then I think it is not advisable to have this feature as the Server would become very heavy.

I read an article on Velocity, but cannot implement that for a POC.

Kindly suggest.

Thanks in advance.

推荐答案

阅读下面的文章将为您的查询提供正确的答案

http://www.eggheadcafe.com/articles/20030716.asp [

Read following article will give proper answer for your query

http://www.eggheadcafe.com/articles/20030716.asp[^]

进入

Go for NCache . Expectantly this will solve your problem as I’m also using it for this type of solutions.

这篇关于数据缓存和SQL缓存依赖关系的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！