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.

Understanding Correlated and Uncorrelated Sub-queries in SQL

August 24, 2017 by “No Bugs” Bunny


Quote:

A correlated sub-query is a type of query, where inner query depends upon the outcome of the outer query in order to perform its execution.

Another Quote:

Correlated sub-queries are slower.

Filed under: On.ProgrammingTips and Tricks

Tagged With: SQLDatabase
Read more

OLTP DB Optimizations 101 - Thinking in Terms of Execution Plans

August 22, 2017 by “No Bugs” Bunny

OLTP DB Optimizations 101 - Thinking in Terms of Execution Plans - Post preview image

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

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

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

The Importance of Back-of-Envelope Estimates - Post preview image

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