can arangodb be used as a memory first cache?

[kaivaan]

my scenario is I will use it for a multiplayer game data or a medium for matchmaking

I need it in a scenario of high-update-read but low in insert, there is very little relational stuff

its closer to key-value but would like to update it like a sql table.

or should I use a different solution?

[Wilfried Gösgens]

https://www.arangodb.com/docs/stable/administration-reduce-memory-footprint.html explains how the rocksdb block cache works, and how your queries benefit.

If you have a "Hot set" this will definitely benefit from more ram & block caches.