I have a project where I have a orders table. Here, every 10 seconds, I send newly arrived orders to the mobile application, other API services, and internal services. However, in doing so, I’m currently using Node.js to send a SELECT query to the database every 10 seconds, which puts a lot of load on the database. Is there an alternative solution I can use?
Installing Redis crossed my mind, but it’s installed on multiple hosts and it’s not feasible for me to set it up right now.
3