View Single Post
Posts: 84 | Thanked: 459 times | Joined on Sep 2012 @ Germany
#164
Originally Posted by knobtviker View Post
Please, pretty please, make smart SQL queries. Multi row inserts, nested queries and such. Do not sacrifice speed just because it's easier to run a for loop and 100 SELECTs inside...
Sounds easy enough. The thing is: the first version of the cache used the app SQL db. But as most of the data is actually pretty dynamic (likes, comments, even users) the second version used only memory (with a given limit). I somewhat question that it's necessary to permanently store images and users when they're outdated a couple of hours later anyway.