“No Bugs” Bunny
OLTP 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 moreThe Importance of Back-of-Envelope Estimates
August 8, 2017 by • “No Bugs” Bunny
Quote:
trying to optimize out a 3e-7 performance hit is very rarely worth the trouble.
Another Quote:
With 4S/4U boxes having typical MTBFs of 3–5 years, the next question we should ask ourselves, is “Hey, will we really be able to write software which crashes much more rarely than that?”
Filed under: On.System ArchitectureRequirement analysisDesign decisions
Read more




