I need to get a set of results from the db (server) but at times I would get the same result back and I would like to cache the result instead of making the same call to the db. Any ideas?
mtyide 0 Newbie Poster
Recommended Answers
Jump to PostAs I read https://dev.mysql.com/doc/refman/5.7/en/query-cache.html my view/answer is I wouldn't bother optimizing in this situation.
Jump to PostThe query cache, that rproffitt linked to, used to cache MySQL result sets for situations where an identical query is made and there have been no table writes to any of the tables involved in the query. However, it has since been deprecated.
I recommend using something like Memcached …
All 6 Replies
rproffitt 2,572 "Nothing to see here." Moderator
Dani 4,084 The Queen of DaniWeb Administrator Featured Poster Premium Member
rproffitt commented: Oh my. Times change so I must too! +16
Dani 4,084 The Queen of DaniWeb Administrator Featured Poster Premium Member
rproffitt 2,572 "Nothing to see here." Moderator
Dani 4,084 The Queen of DaniWeb Administrator Featured Poster Premium Member
rproffitt 2,572 "Nothing to see here." Moderator
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.