News for hackers. Stuff that matters.
Re:Poor Man's Scalability by jacques_chester on Saturday October 15, 2011 @10:50PM (#3116384)
> [1] This is database 101 stuff - a class I never took.

Yes, yes, a thousand times yes.

The best and most important way to improve database performance is to have a sensible schema. Query planners can do magic with stuff that's sensibly normalised and with things that are sensibly denormalised.

Where they choke is on schemata where everything is just squished into a bunch of tables with fields holding internal datastructures.

There are no comments on this comment yet.