4 ms·
Spending money on Oracle or moving to Postgres will just make things worse. At that scale you need to do 2 things, denormalize and cache. (And, if you're FB
by jbooth 15y ago
Spending money on Oracle or moving to Postgres will just make things worse.
At that scale you need to do 2 things, denormalize and cache. (And, if you're FB, buy 75% of FusionIO's production). Big complicated queries just don't scale like simple key-value lookups, especially if they impose locking constraints on your database or try to join against things that are sharded to different servers.
Doesn't really matter what database back-end you're using if you're only using the dead-simple features.
- gaius 15y agoIt depends what you mean by "spending money on Oracle". They'll happily sell you TimesTen or Coherence as well as the classic RDBMS remember. And the classic RDBMS in the right hands is bloody quick.