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.

OLTP DB Optimizations 101 - Thinking in Terms of Execution Plans

August 22, 2017 by “No Bugs” Bunny

DB Optimizations: Execution Plans

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 more

Allocator for (Re)Actors with Optional Kinda-Safety and Relocation

August 15, 2017 by “No Bugs” Bunny

Effects of External Fragmentation on Memory Usage

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

The Importance of Back-of-Envelope Estimates

August 8, 2017 by “No Bugs” Bunny

Back of the Envelope Calculations: Fermi Problem

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

(Not Really So) New Niche for C++: Browser!?

August 1, 2017 by “No Bugs” Bunny

C++ in Browser

Quote:

asm.js has invented its own instruction set, which can be still seen as an instruction set of a CPU, at least from the point of view of a C++ compiler.

Another Quote:

As asm.js is a strict subset of JavaScript – it will run even if there is no special support for asm.js in browser.

Filed under: On.ProgrammingProgramming Languages

Read more