Re:Ask HN: What made SQL databases so popular?
by VLM on Sunday March 10, 2013 @08:54AM
(#5351667)
"the on-disk overhead of a SQL database is fairly limited"
The ___minimum___ on-disk overhead...
At run time after deployment after growth sometimes I have to scramble adding indexes and depending on the business demand for "instant" online reporting or query speed, you can end up with a ridiculous number of large indexes. Which also has a negative, hopefully survivable effect on insert/update/delete speeds. I guess I'd add:
* tunability - the DBA decides at the DB level based on defined business requirements how to trade disk space for read speed.
The ___minimum___ on-disk overhead...
At run time after deployment after growth sometimes I have to scramble adding indexes and depending on the business demand for "instant" online reporting or query speed, you can end up with a ridiculous number of large indexes. Which also has a negative, hopefully survivable effect on insert/update/delete speeds. I guess I'd add:
* tunability - the DBA decides at the DB level based on defined business requirements how to trade disk space for read speed.