April 10th, 2013

Day three starts off by introducing a database containing movies, actors and their relationships. We have a many to many relationship between movies and actors, modeled by a join table along with indexes on its foreign keys to speed lookup. Join tables and reverse index lookups like this are where speed can suffer with RDBMS, […]