Has-and-belongs-to-many relationships are quite common, but they require some special database/index love to make sure their performance stays up as data volume increases.

Read more »