Reputation
Next tag badge:
436/400 score
75/80 answers
Badges
5 109 215
Newest
 Enlightened
Impact
~1.4m people reached

Apr
19
comment Maximising data processing speed: in-memory or write to db first?
We still do not have enough information to answer your question - why don't you edit your question and give a short outline about the details, an example etc? We cannot tell you what went wrong in your C# code when we do not know what it does. Your DB is probably indexed; for getting similar or better performance in C#, you will typically have to utilize a Hashset or Dictionary. But without knowing more of your requirements or your code, this is just wild guessing.
Apr
19
comment Maximising data processing speed: in-memory or write to db first?
@MattThrower: can you please elaborate how you encoded those "700 possible obscenities" into one (huge?) SQL query? An example would really be clarifying. When it comes to performance, those details are important, otherwise this will end up in wild guessing.
Apr
19
comment Maximising data processing speed: in-memory or write to db first?
@MattThrower: from your question, it is unclear if your "one query" does the same as your comparison against that "list of ~700 possible obscenities", or where the equivalent of the latter happens in your MySql solution. Please clarify.
Apr
19
awarded  Good Answer
Apr
18
revised Most efficient strategy for search large text areas for multiple values
added 193 characters in body
Apr
18
comment Most efficient strategy for search large text areas for multiple values
@Lobsterpants: having no optimization prepared is not a weakness in the design - but having unneccessary optimization is. It is typically much easier to evolve simple code for new requirements than "optimized" code. I heavily recommend to optimize your code when the new requirements arrive, only after you implemented them in the most simple possible approach, measured the performance again, and you know for sure your perfomance is bad, not "just in case"
Apr
18
revised Most efficient strategy for search large text areas for multiple values
deleted 1 character in body
Apr
18
answered Most efficient strategy for search large text areas for multiple values
Apr
18
comment How to write correct loops?
@CodeYogi: no need to insult me. I was neither the one who wrote the answer, nor the one who obviously misinterpreted this answer (you will find plenty of posts here on PSE explaining you the differences between testing and TDD). My opinion: this answer is good advice to your question when you read it carefully, completely, and understand what it means.
Apr
17
comment How to write correct loops?
@CodeYogi:where in this answer do you actually read "TDD"? Did you mix up testing with TDD? Where in this answer do you read "test (or TDD) is the one and only solution to the problem you were asking"?
Apr
17
revised What is Big O of sqrt(1) + sqrt(2) + … + sqrt(n)?
irrelevant parts stripped from the question
Apr
17
comment How to open 2 Visual Studio instances, with same Git projects and different branches
This is off-topic on this site, better move the question over to stackoverflow.
Apr
17
answered How can I make a boss (or colleague) be more careful when estimating the complexity of a task/project?
Apr
16
revised Why don't languages that have big integer support have unsigned versions?
added 170 characters in body
Apr
16
comment Is there a good reason to run 32-bit software instead of 64-bit on 64-bit machines?
@gnasher729: my comment should only point out that the OP has asked his question in an IMHO very biased tone like "64 bits are clearly better than 32, so why should we still use this 32 bit crap?" - which is nonsense. There is no general "one is better than the other" in here. Luckily, he got good answers which pointed that out.
Apr
16
comment Is there a good reason to run 32-bit software instead of 64-bit on 64-bit machines?
@rhughes: your links tells quite the opposite than your comment. Typo?
Apr
16
revised Best way of writing comments in code
added 46 characters in body
Apr
16
answered Why don't languages that have big integer support have unsigned versions?
Apr
16
comment Why don't languages that have big integer support have unsigned versions?
@RobertHarvey: I would say this is an additional property which might be important in some contexts, less important in others.
Apr
16
comment When software rots, what property of the system changes?
You can call it "quality of the source code" or Software Entropy, that would enclose pretty much everything which can become worse by constant maintenance. However, this is still opinionated (and I am not a fan of "technical debt", sounds too metaphoric too me and can be too easily misinterpreted.)