I'm old and forgot how to SQL, so instead of re-learning SQL I just fetch and store individual rows and do everything else in Python. Like an animal.
-
You are over estimating my average client ;) I’ve seen a lot...
Well, have a laugh: I just re-discovered that count(DISTINCT ...) exists. So I'm now fixing the queries where I do something like SELECT count(*) FROM (SELECT 1 FROM ... GROUP BY ...); But here's the real question: "COUNT" or "count"? :D
-
-
But that’s no big issue—bulky but not disastrous. Upper case tells the database that it is urgent ;)
-
So maybe I should be using uppercase COUNT here to, you know, speed it up a bit.. :Dpic.twitter.com/zesABoljv5
- Show replies
New conversation -
-
-
Ouch.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.