Reputation
6,033
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
13 49
Impact
~220k people reached

May
12
answered Non-ambiguous wording for 'Backend'
May
8
comment How to quickly search through a very large list of strings / records on a database
In my opinion the fulltext options in any RDBMS is a workaround to make it do something it isn't designed for: "search in some pile of unstructured unrelated data". If you're building a searchengine, you just don't use an RDBMS. It may work for small datasets but lakcs any sort of scaling. Searching through piles of unstructured data is not a nail, so don't use a hammer. Use the right tool for the job.
May
8
comment How to quickly search through a very large list of strings / records on a database
The problem as stated doesn't seem like a good fit for an RDMS anyhow.
May
6
comment Read complex data from a relational database through a join or through concurrent requests?
Concurrent access to the database also has a lot of overhead.
May
6
comment What's the best way to handle Windows API errors in response to system messages or when I have nowhere to return them to?
@Deduplicator the harmless error are actually errors where you know what to do with them.
May
5
awarded  Nice Answer
May
1
comment Finding the first index in which the element and the index are the same
Make code that keeps using the original list instead of recursive code that splits the list into new lists.
Apr
28
answered List comparing techniques for faster performance
Apr
28
comment List comparing techniques for faster performance
50k and 400k aren't particularly big lists. two foreach cycles or Linq this will get you O(n^2) time complexity and yes that is a slow approach.
Apr
24
comment Is String processing more complex than number processing in programming languages?
In most programming languages strings are a layer of abstraction on top of numbers. So when you're processing strings, under the hood the computer translates it to numbers and processes numbers.
Apr
23
comment Using JOIN keyword or not
@RemcoGerlich why it has been deprecated isn't under discussion here. What's under discussion here is whether to use the old or new syntax. Whether one is better then the other or not is moot: you shouldn't use old syntax. The why question is another discussion. (one that has been settled 20 years ago.)
Apr
23
answered Using JOIN keyword or not
Apr
23
comment Using JOIN keyword or not
I also tend toward that style to minimize surprise I think you just answered your own question. Surprises are bad.
Apr
22
comment Any library or dll to use to give a free lancers project from clients who accept your work but not pay
Even if it's written well, it may still be nonsense. If your userbase is low enough and not too tech savy DRM works surprisingly well. And it is just not that simple.
Apr
22
comment Any library or dll to use to give a free lancers project from clients who accept your work but not pay
There are lots of ways DRM can work, especially in the kind of situations the OP is talking about. I know it's popular to kick against DRM but there are nice technological measures to make this work. Not waterproof, but waterproof enough.
Apr
21
awarded  Nice Answer
Apr
21
answered Does using a database server make sense if the application only does things locally?
Apr
20
answered Big O Question about an algorithm with (n^2 + n) / 2 growth rate
Apr
16
comment Entire webpage obfuscation
If you need to obfuscate your php you are doing it wrong.
Apr
6
awarded  Yearling