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

Execution Plans with no index, single-column index, and multi-column index

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 more

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

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