this thread clearly needs more Ely...
good morning everypony
I feel the need to post full pic of my avatar, because it's simply that awesome.
Pinkie Pie may be the best pony in the show, but nopony can steal a picture like Twilight.
Thread needs some more Discord.
Well atleast it is doing _some_ caching, instead of blindly dumping queries to the SQL server.
I'd imagine, in Curse's case, the MySQL servers are clustered. But if the queries are being ran through without any optimization, you will have troubles when trying to do a SELECT * FROM posts without a query limit for example. Hence you'd assume they'd hide deleted posts by default and make them available for viewing in a completely separate view (as in phpBB if memory serves) and therefore keeping the thread all nice and fast.
At least they'd have a good selling point if they fix the legacy code :3
Anyhoof, ponies:
See http://ask-princessluna.tumblr.com/p...rd-to-get-used for full size :3