Far Cry 3 editor jazzed up with Blood Dragon shinies
Epic Mickey 2 for Vita coming June 18
Poker Night 2 antes up on iOS
Warhammer Quest hitting iOS May 30
Super Stardust dev making 'spiritual successor' for PS4
Morning Discussion
by Xav de Matos, Jan 03, 2011 5:00am PST2010 is over. Time to start clearing space on our shelves for the swarm of new titles hitting in 2011. In the first three months alone we're going to be bombarded with quality titles. Then a steady stream of other anticipated games are going to trickle out. In November we have Uncharted 3 landing and my personal "OMGOMGOMG" game of 2011, The Elder Scrolls V: Skyrim, arrives. Then Gears of War 3 and, well, all those games that have yet to be revealed.
This generation makes me happy to be a gamer. You know who else is happy? Credit card companies and loan sharks; the only two options I use when making mass video game purchases. What I'm saying is, I make bad decisions.
I need some way to profile a query that's taking an inordinately long time to run. I've already done an EXPLAIN and it comes back as I expect - its not using a key on one of three tables in a join, and of course that means its stepping through 25k records to find a match. Funny thing is, I'm joining on the primary key, so I don't know WTF is preventing it from joining faster.
Here's the query:
https://gist.github.com/763987
NOTICE: I didn't write this stupid query.
Thread Truncated. Click to see all 13 replies.
You must be logged in to post.