: The Node Express server is returning "304 Not Modified" responses, but only after querying the database I'm just diving into web developent, my current passion is Express (Node.js). I've noticed
I'm just diving into web developent, my current passion is Express (Node.js).
I've noticed then i often recieve HTTP/1.1 304 Not Modified either for static content and (!) for my json API requests (when data is still the same, so this is actually correct). But my node console log shows that SQL querys are executed every time API requested.
It seems like requests from my front-end are cached, but the cache does not actually prevent my back-end from executing redundant SQL querys. Hmmm...
Can anyone shed some light onto what is actually going on here?
More posts by @Jessie594
1 Comments
Sorted by latest first Latest Oldest Best
The framework is:
Generating the page internally for every request
Using ETag headers with a content hash function to compare the generated page with the version sent before
Either sending the full page, or a "Not Modified" response based on the hash comparison
Because your content is database generated, the framework has to assume that it is dynamic and can change with every request. Therefore it must execute all the queries and generate the page before it compare to the version the client actually has.
I'm not familiar with Express, but most frameworks have a mechanism where you can cache the results of SQL queries for some amount of time to reduce the load on the database.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.