if something is compute heavy should it be better of handled in database sql or nosql or directly at nodejs with nosql or redis

feels like i should handle zero for loops and global variables in nodejswill it be too much if i put everything on database?i wanted to design a system the utilizes temporary/dedicated tables let say i want to make a game. room is created and everything that is needed by the players during that session it is managed in a temporary table only when the game ends it gets transferred to the main table or something like this is better of in a mongodb?feels like redis is fast but very limiting only better of as a cache server.

Submitted September 23, 2020 at 08:04AM by KommSur