2017-05-09, 12:48
My 2 cents: If queries and performance are already highly optimised, move on to intelligent caching. For example, if each thumbnail on a network resource generates a query, copy it or at least a thumbnail locally and load it from there. Leave all costly queries for scraping and load as much as possible from cache for sorting and such. Maybe this could be done through a dedicated add-on, like simplecache does.