<1/4>

“No Bugs” Bunny

unnamed.png

“No Bugs” Bunny
Sarcastic Architect

Hobbies: Thinking Aloud, Arguing with Managers, Annoying HRs, Calling a Spade a Spade, Keeping Tongue in Cheek

BB_userpic_0012.png

Once upon a time, in a rabbit outsourcing warren of Bunnylore, there was a young software developer bunny. And as a developer, she has had one very unusual treat: she was obsessed with eliminating all the bugs she can get his forelegs on. So, it is not surprising that her friends called her a “No Bugs” Bunny (or simply “NoBugs”).

Later on, she grew up, so she decided that “Bunny” in her name has became inappropriate (not to mention potential arguments with Warner Brothers), so she has asked all her friends to call her “No Bugs” Bunny. She has made a career as a team lead and software architect, and they lived happily ever after.

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

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