If you're in trouble and cannot find an answer to a question which goes beyond Stack Overflow...

If you have a not-so-usual solution for your problems but need to justify it to your boss...

If you like to think on your own rather than blindly follow "common wisdom" and "profound truth"...

...then 'No Bugs' Hare on Soft.ware might be the right place for you.

Your mileage may vary. Batteries not included

Assorted Rants Tagged ‘OLTP’, page 2:

Databases and RAIDs

posted May 30, 2017 by "No Bugs" Hare

Quote:	“for quite a few applications out there, the most important feature of the RAID is not even redundancy, but greatly improved write latency. Moreover – this is the thing which we cannot possibly get from software RAID (!).”
Another Quote:	“As a rule of thumb – I am trying to keep the size of OLTP DB small enough to fit into RAM of the OLTP DB Server.”
	[→]

posted December 13, 2016 by "No Bugs" Hare

Quote:	“to make an efficient representation usable for OLAP – we need to modify our data on its way to OLAP replicas”
Another Quote:	“Each of the DB Server Apps is a replica master, but all replica targets are within the same Replica DB”
	[→]

posted November 28, 2016 by "No Bugs" Hare

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)”
	[→]

posted November 21, 2016 by "No Bugs" Hare

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”
	[→]

posted November 14, 2016 by "No Bugs" Hare

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.”
	[→]

posted November 7, 2016 by "No Bugs" Hare

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”
	[→]

posted October 31, 2016 by "No Bugs" Hare

Quote:	“Dealing with transaction isolation is very far from being a picnic”
Another Quote:	“One of such real-world systems was consistently processing over 30M real-world write transactions/day over one single DB connection, supporting ~100K simultaneous players.”
	[→]