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 ‘Database’, page 2:

Scaling Stateful Objects

posted June 27, 2017 by "No Bugs" Hare

Quote:	“it is DB which is usually The Bottleneck™ – it means that we’re saving this enormous amount of load, exactly where it really matters.”
Another Quote:	“as discussed above, the real-world task is always about scaling the whole system, including database; and in this regard Stateless-App-based systems exhibit significant problems.”
	[→]

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 January 9, 2017 by "No Bugs" Hare

Quote:	“Fortunately, there is a neat crypto-trick which makes this schema usable for Server-oriented games in general – and multi-player games in particular”
Another Quote:	“if you’re using TCP to communicate, you should log everything right before it goes into your send() call (and right after it comes out of your recv() call”
	[→]

posted January 3, 2017 by "No Bugs" Hare

Quote:	“With the Direct Processing, customer should trust us (the merchant) with their details”
Another Quote:	“On the other hand, most of PCI DSS requirements make perfect sense regardless of formal compliance”
	[→]

posted December 20, 2016 by "No Bugs" Hare

Quote:	“Chargeback monster will come from under the bed and will eat all your hard-earned money!”
Another Quote:	“it is trivial to develop a system with guaranteed zero chargeback rate – to achieve this, it is sufficient to decline each and every transaction at pre-filter stage”
	[→]

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 December 5, 2016 by "No Bugs" Hare

Quote:	“while duplication MAY indeed improve performance – undue duplication also MAY hit performance pretty badly”
Another Quote:	“NoSQL will usually call for another denormalisation on top of what we’ve described above for SQL-with-XML.”
	[→]