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)

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

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.

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