scaling x

19 Jun 11

Joins are fast (stackoverflow.com) permalink
Joins are fast. Joins should be considered standard practice with a properly normalized database schema. Don't fear the join.

It's true that join performance degrades non-linearly as the size of the data set increases. Therefore, it doesn't scale as nicely as single table queries, but it still does scale.

It's also true that a bird flies faster without any wings, but only straight down.

21 Apr 11

Lucene Solr (lucene.apache.org) permalink
Solr is the popular, blazing fast open source enterprise search platform from the Apache Lucene project.