On.System Architecture
System Architecture (and it’s subfield Software Architecture) is a discipline which is surprisingly poorly covered. In a sense, it is still more an art than a science, and usually requires somebody intimately familiar with practical systems, to tell what’s to do and what’s to avoid when building a system.
IT Hares have lots of experience in both Software Architecture and more general System Architecture, and are trying to share their knowledge (and more importantly, their feelings) about them.
OLTP. Compiling SQL Bindings.
November 28, 2016 by • “No Bugs” Bunny
Quote:
If we’re speaking about millions transactions per day over just a few hundred of different SQL statements – compiling those statements a million times (instead of a few hundred times) will be a dramatic waste of resources.
Another Quote:
Once upon a time, I observed the largest C++ file in my career – it was a 30’000-line file(!) consisting merely of ODBC bindings (and that was just for 300 or so SQL statements)
Filed under: On.System ArchitectureDesign decisionsBook: D&D of MOGs1st beta of Vol. IV-VI
Read moreHistorical Data in Databases. Audit Tables. Event Sourcing
November 21, 2016 by • “No Bugs” Bunny
Quote:
99% of reporting requests and 99.9% of analytics is purely historical
Another Quote:
Information within the audit table should be sufficient to validate/justify current state
Filed under: On.System ArchitectureDesign decisionsBook: D&D of MOGs1st beta of Vol. IV-VI(Re)Actors
Read moreChoosing RDMBS for OLTP DB
November 14, 2016 by • “No Bugs” Bunny
Quote:
As the RDBMS keeps modifying its tables – the tables gradually degrade
Another Quote:
As we can see from the table above – choosing your RDBMS it is not as easy as it might seem.
Filed under: On.System ArchitectureDesign decisionsBook: D&D of MOGs1st beta of Vol. IV-VI
Read moreUltimate DB Heresy: Single Writing DB Connection. Part II. Gradual Scalability. All the way from no-scale to perfect-scale.
November 7, 2016 by • “No Bugs” Bunny
Quote:
And after this split of USERS table, the system has achieved perfectly linear scalability.
Another Quote:
Start with a simple single-write-connection DB, with reporting running off the same DB
Filed under: On.System ArchitectureDesign decisionsBook: D&D of MOGs1st beta of Vol. IV-VI(Re)Actors
Read more
Six Impossible Things Before Breakfast Ltd. © 2026. All rights reserved.
