Implementing Searches / Galleries
Implementing search, gallery results for a given user's profile and similar use cases. A lot of caching and efficiency considerations.
Introduction
Efficiency: SQL and caching
Optimising the SQL query
Optimising a query of this size can seem a very daunting task. In reality, there are a handful of...
Caching results
If your gallery SQL query is run every time a user performs a search or loads a gallery, it's goi...
Caching dangers (user safety)
Because retrieving data specific to the requesting user is a huge caching inefficiency, we need t...