Disclosure: On this site you won’t find specific advice on “how to call function xyz()”. Interpreting C++ ARM and #pragma dwim is also out of scope.
We’re treating our readers as intelligent beings who can use Google and/or StackOverflow, where all such specific questions were answered more than once.
What you will find is opinions, more opinions, and even more opinions on all the aspects of software development - and with a large chunk of them based on real-world experience too.
Your mileage may vary. Batteries not included.
DB Execution Plans for C++/Java Developers, and for anybody who has read Knuth
August 29, 2017 by • “No Bugs” Bunny
Quote:
If I was a compiler-with-ability-to-create-indexes-as-I-need-it – what would I do to make The Ideal Execution Plan™ for this request?
Another Quote:
When we have that ideal-execution-plan – we still need to convince our SQL compiler to use it
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IX
Read moreOLTP DB Optimizations 101 - Thinking in Terms of Execution Plans
August 22, 2017 by • “No Bugs” Bunny
Quote:
to realize how our queries are working – we need to start thinking in terms of so-called “execution plans”.
Another Quote:
it can be faster to use Table Scan rather than Index-Scan+fetch over such a low-selectivity index
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IX
Read moreAllocator for (Re)Actors with Optional Kinda-Safety and Relocation
August 15, 2017 by • “No Bugs” Bunny
Quote:
Safe with relocation’ mode will allow us to eliminate dreaded ‘external fragmentation’ – which tends to cause quite a bit of trouble for long-running systems
Another Quote:
For a long while, I have been a strong proponent of message-passing mechanisms over mutex-based thread sync for concurrency purposes
Filed under: On.System Architecture(Re)ActorsOn.ProgrammingOptimizations
Read more


