0

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.

user1034912
  • 2,153
  • 7
  • 38
  • 60

2 Answers2

1

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...

SQLpro
  • 3,994
  • 1
  • 6
  • 14
  • Sorry I don't understand what you imply here. Are you saying that Redis is overkill? – user1034912 Mar 15 '22 at 12:08
  • There is no need to have a Redis database if your DBMS have the same features as REDIS ! In some RDBMS Like Microsoft SQL Server, you can use in-memory tables that deliver exactly the same service in addition to usual relational tables. – SQLpro Mar 15 '22 at 15:22
  • Thanks, then what the hell is redis for then? – user1034912 Mar 15 '22 at 17:01
0

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

Renshaw
  • 1,075
  • 6
  • 12