Im stuck trying to develop a way to display featured threads on the index of my site for my imageboard backend. The only method i can think of that doesn't involve a clusterfuck of code is to query the database for every top post anytime a user logs into the index, but that still sounds awfully inefficient considering how minimal of a detail it ends up being. Any tips for this sort of stuff? I tried to look at how vichan does it but i didn't really get it tbhdesu.