I was looking at using data caching with database dependency for a web farmed ASP.Net app. So each web server in the web farm would automatically refresh its Cache value as soon as the database value changes. This would appear to keep all Cache values across the web servers synchronized. Does this sound like a good idea or I am missing something?
In ASP.Net web farm is database dependent Caching a good approach?
774 views Asked by Sunil At
1
There are 1 answers
Related Questions in ASP.NET
- Implementing Azure AD B2C Authentication in .NET 8 Blazor Project (RenderMode: InteractiveAuto)
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- IIS Rewrite Module exclude bots but allow GoogleBot
- Angular 16 sending null values to API
- I am the domain admin, newbie, how do I connect youtube.com on my domain?
- Dropdown list showing SQLServer2005SQLBrowserUser$DONSERVER instead of Active Directory group name in ASP.NET MVC C#
- ASP.NET Identity, Losing Ability to Login until Application Pool Recycles
- How to unprotect ASP.NET FormAuthentication cookie
- How does it work using ASP.NET FormAuthentication
- What is the purpose of a completely standalone 'this'?
- Is there a way to read .csproj PropertyGroup variable in c#
- MSBuild trying to copy different dll with similar name into project sporadically
- Minimizing IdentityServer4 Round Trips in Microservice Architecture with Ocelot
- Azure AD guest account in web app authentication user claims data
- Receiving 400 bad request on post when customer auth handler is used
Related Questions in CACHING
- Using Puppeteer to scrape a public API only when the data changes
- Caching private wordpress rest endpoints
- Cloudflare not respecting Cache-Control
- Unexpected Recursive Call
- Cannot serialize (Spring Boot)
- Nginx only caches file endpoints
- The Selenium application properties folder holds two environment options. After running a test the environment setting changes to a previous setting
- Launch jobs in cache in a loop in bash script
- Multiple async request do not store anything to cache
- Dev tool for Next.js cache on the client?
- Creating a letter in the terminal by entering
- Laravel: check if cache has key with thag
- The retrieval time for the Apache Ignite cache is too long
- How to run gradle with caches files
- Docker Run cache mount does not cache apt-get dependencies
Related Questions in WEB-FARM
- Antiforgery token with Blazor .Net 8 on a web farm - machinekey not used
- Web Farm with IIS10 Servers | Content Server: HTTP Error 500.0 - ASP.NET Core IIS hosting failure (in-process)
- Set the default focus of an aspx page onto a button
- Using Azure AD for authentication, we sometimes get CORS or Access-Control errors during partial page updates
- How to change a boolean value in FARM
- IIS 10 ARR LoadBalancer Working more like Redundent Web Servers
- How to send request to another server with IIS ARR if a timeout occurs?
- Asp.Net Core: Sharing authentication cookies in Web Farm doesn't work
- ASP.NET Identity Core: invalid token for password reset on web farm
- High Availability ASP.Net MVC on Azure Web App throwing 500 Internal Server Error
- AppDomain handy information lost in load balanced scenario
- SSL CSR for server farm on IIS
- Kentico 9 Web Farm Synchronization
- Using Web Deploy to synchronize web application files
- How do I deploy an Asp.Net Core app on a web farm?
Related Questions in SQLCACHEDEPENDENCY
- How to customize output cache action filter where it's cache by sql query in mvc
- Simple SqlCacheDependency
- Memory cache with sql cache dependency
- "Current user *** have no permission.",it showed this while using SqlCacheDependency and HttpRuntime.Cache.How to solve it?
- Calling SqlDependency.Start two times continuously, the second time failed?
- How to remove the "user specific data-cache" once the session(In Proc) gets timeout in ASP.Net?
- .Net core SQL cache dependency
- How to my stored procedure make it fast and beautiful...( select . select. select.. )
- How to add caching to my MVC Application and WCF Service
- Differences between SqlDependency and SqlCacheDependency
- Using SQLDependency or SqlCacheDependency with Repository pattern
- Use wildcards when searching in HttpContext.Cache
- Regarding how sql cache dependency works
- How do I programatically modify the SqlCacheDependency section of web.config
- Asp.net MVC SqlCacheDependency
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
No. It does not mean all servers will refresh once the value in the db refreshes, unless you use something like SqlCacheDependency. Take a look @ the following link for that: http://www.asp.net/web-forms/tutorials/data-access/caching-data/using-sql-cache-dependencies-vb
Otherwise the mechanism simply involves looking into the database and taking the value from there. There might be sql jobs which might refresh the value. Hence it is different from above.
Note: for SqlCacheDependency you need to use MSsql 2005+ server.
The other tecnique would be to employ the use of web hooks in your solution...