Efficiency: SQL and caching

Optimising a query of this size can seem a very daunting task. In reality, there are a handful of...

If your gallery SQL query is run every time a user performs a search or loads a gallery, it's goi...

Because retrieving data specific to the requesting user is a huge caching inefficiency, we need t...