When building an express app, should I query the database every request, or cache the results in the app itself? If I cache the results, how much can I cache?

I currently have an express app which uses a mysql database. It's a simple website with a small number of articles...maybe 100-ish. I could easily just query the entire database when I spin up the server and store all of the entire database in variables.But how much is too much in terms of caching? How do devs normally manage this in node?

Submitted August 23, 2017 at 02:20AM by EducationalSoftware