Had a good day today. Sped up a critical algorithm by almost 3 orders of magnitude
Always a great feeling.
It's like "Shit, I had to have missed something, this used to take 5+ seconds to run and now it's done in 50ms" then slowly you realize, nope, shit was just slow/badly written to begin with :\
UPDATE dTable SET device = {0}
Your query is bad. This UPDATE is setting EVERYTHING to whatever {0} is since you have no where clause.