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 Optimization 102: DYI Heterogeneous Replication. Part I (Basics)

October 24, 2017 by “No Bugs” Bunny

OLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics) - Post preview image

Quote:

there are still several Big Fat Reasons™ to use DIY replicas

Another Quote:

With the Replication Messages described above, it is ok to apply Replication Messages to Slave DB which is newer than exactly necessary.

Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations

Read more

OLTP DB Optimizations 102 – Group Commits

October 17, 2017 by “No Bugs” Bunny

OLTP DB Optimizations 102 – Group Commits - Post preview image

Quote:

if we can commit several transactions at the same time – RDBMS needs to fsync() our DB logs to physical disks only once

Another Quote:

if going our preferred way of single-writing-DB connection – make sure NOT to use RDBMS-level Group Commit

Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations

Read more

OLTP DB Optimizations 102 –100% Coherent App-Level Cache for Single-writing-DB-connection

October 10, 2017 by “No Bugs” Bunny

OLTP DB Optimizations 102 –100% Coherent App-Level Cache for Single-writing-DB-connection - Post preview image

Quote:

with our app-level cache, we’re guaranteed to get exactly the same results as if we’d be querying the underlying database.

Another Quote:

why settle for invalidation when we can modify cache accordingly, saving on the extra DB request when we’re dealing with the same USER again?

Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations

Tagged With: DatabaseOLTPCache
Read more

Eight Ways to Handle Non-Blocking Returns in Message-Passing Programs - with Script

October 3, 2017 by “No Bugs” Bunny

Eight Ways to Handle Non-Blocking Returns in Message-Passing Programs - with Script - Post preview image

Filed under: On.System Architecture(Re)ActorsOtherAnnouncements

Read more