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

OLTP. Compiling SQL Bindings.

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 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 October 24, 2016 by "No Bugs" Hare

Quote:	“in real world, after deployment, most of the changes in DB structure are about widening columns and adding the new ones”
Another Quote:	“For documents and BLOBs, NoSQL is a natural habitat”
	[→]