Dying Light brings parkour to land of zombies
Grand Theft Auto 5 Special Edition, Collector's Edition, pre-order bonus unveiled
Rumor: Slant Six was working on Medal of Honor Vita game
Simpsons, King of the Hill writer joins Angry Birds film
Class of Heroes 2 coming to PSN on June 4
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.