CODEWITHSUNDEEP
redisrdbms
user1034912
user1034912

Reputation: 2267

Why is Redis used as an RDBMS cache when an RDBMS also has it's own cache?

Ok this maybe a silly question to you, but really please... i don't understand:

Why is Redis used as an RDBMS cache when an RDBMS also has it's own cache?

Both Redis and RDBMS is on the same server, or possibly even the same data center local area network.

Thank you.

Upvotes: 1

Views: 408

Answers (2)

SQLpro
SQLpro

Reputation: 5167

This is a common mistake since some RDBMS like Microsoft SQL Server can use in-memory tables (Memory Optimize Table).

So you can have the same cache as Redis, without paying more and having much more machines, resources and management to do so...

Just have a look on : Introduction to Memory-Optimized Tables

Some other big RDBMS like Oracle have the same functionality but you have to pay for...

Upvotes: 1

Renshaw
Renshaw

Reputation: 1155

RDBMS only have limited optimizations with cache while Redis can be used to do customizable cache.

Upvotes: 1

Related Questions