1. Another story competition is beginning! (Q1 2018)

    "You're bleeding on my floor."

    We've moved to a quarterly format, so you really have no excuse not to participate this time.

    So check out the new thread discussing scoring, rules, and other such matters in the in the Story Competitions forum and get cracking.

    Dismiss Notice

Techblog: Current development: Memcache, Tagging

Discussion in 'Techblog' started by PatronusCharm FeedBot, Jul 1, 2008.

  1. PatronusCharm FeedBot

    PatronusCharm FeedBot RSS/Atom Feed Poster Bot

    Joined:
    Jan 6, 2008
    Messages:
    15
    I, as a developer, have an insatiable urge to optimize, simplify, and speed up my code. There are developers out there that would have no qualms running a query like this every time somebody hit their site. SELECT (SELECT COUNT(userid) FROM users) AS users, (SELECT COUNT(id) FROM reviews) AS reviews, (SELECT COUNT(chapterid) FROM chapters) AS chapters, [...]

    Full article