ASP.NET Core distributed cache with Redis or SQL Server

Question

I'm looking at using Redis or SQL Server for storing sessions in ASP.NET Core, and maybe some other caching needs. A few quick questions:

Are there any major differences with the two?
Redis is in-memory, is SQL Server also for this purpose, or does it store everything on disk?
Would the SQL Server Express -version be enough

Good read about the redis vs sql distrubuted caching performance at stackoverflow.com/questions/62881953/…. spoiler: sql wins for the listed particular case — FatalError
– FatalError, Commented Sep 18, 2023 at 11:19

Cihan B. · Accepted Answer · 2017-02-13 10:40:19Z

6

You may be able to use sql server for session state but redis is purpose built to handle the session state. A SQL based database like SQL Server is likely an overkill for session state management. From a cost of computing a session state lookup, redis will be much cheaper and faster. Redis is lightweight, low latency and more scalable.

Full disclosure, I worked in engineering both product at different times. I work on Redis in Redis Labs these days.

answered Feb 13, 2017 at 10:40

Cihan B.

3371 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1340582 Over a year ago

Yes, but I will use a distributed cache for caching other stuff too :) Anyway, Express is quite lightweight also?

Cihan B. Over a year ago

express is still sql server with a few of the wheels removed but I'd not say it is light weight. BTW - if you are looking for an option for windows you can use redis on docker. There are a few repos I'd recommend; the official redis repo: hub.docker.com/_/redis - the redis-enterprise repo (clustered redis running Redis Cloud by Redis Labs): hub.docker.com/r/redislabs/redis

Collectives™ on Stack Overflow

ASP.NET Core distributed cache with Redis or SQL Server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related