Optimizations

Premature and/or over-optimization is often claimed to be a root of most evil in the programming world. However, what to do when optimization IS necessary?

IT Hares discuss certain not-so-trivial optimization techniques. It doesn’t mean that you should use them at all costs (and most likely, you don’t); however, if you do have a reason to optimize – this information may be handy.

OLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics)

October 24, 2017 by “No Bugs” Bunny

DB Replicas

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

Group Commits

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

Caching

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

OLTP Optimization Cheat Sheets for dbdevs and DBAs

September 5, 2017 by “No Bugs” Bunny

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

Quote:

Have I already mentioned that you DO need to understand execution plans?

Another Quote:

DO keep in mind that maintaining indexes has its own cost

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

Read more