163 reputation
6
bio website cridion.com
location Atlanta, GA
age 29
visits member for 2 years, 1 month
seen Feb 19 at 20:36

Programmer, scientist, thinker.


Apr
4
awarded  Popular Question
Aug
29
awarded  Scholar
Aug
29
accepted Quickly change NULL column to NOT NULL
Aug
29
comment Quickly change NULL column to NOT NULL
@MartinSmith I clarified what I mean by forever. I'm testing this in a dev environment with no other sessions hitting the database. It does eventually complete. But the answer that you linked explains why it takes so long. If you can reword your comment as an answer, then I'll accept it.
Aug
29
awarded  Editor
Aug
29
revised Quickly change NULL column to NOT NULL
edited for clarity
Aug
28
asked Quickly change NULL column to NOT NULL
May
16
comment Efficiently Filter Large Set With Disjunctions
@JonSeigel it depends on how much... but I want to see any suggestions
Feb
6
comment Efficiently Filter Large Set With Disjunctions
@Valkyrie that seems incredibly inefficient. Also consider that variants of this query (different parameters and different optional where clauses) will likely be executing several times a second all day long and need to return results on average in less than 100ms. We already do this, and it performs okay for now. I'm just looking for ideas on how to continue to improve performance for scalability.
Feb
5
awarded  Student
Feb
5
asked Efficiently Filter Large Set With Disjunctions
Nov
15
awarded  Supporter
Jun
26
awarded  Autobiographer