Every time someone clicks a vote , we query out every MovieVote, Movie, and IMDBInfo object separately to refresh, instead of doing a join and a single query to get the movie info and IMDB info together in a single row. We can optimize this from like, 10-20 queries per refresh to 2-3 if we do that join.
Every time someone clicks a vote , we query out every MovieVote, Movie, and IMDBInfo object separately to refresh, instead of doing a join and a single query to get the movie info and IMDB info together in a single row. We can optimize this from like, 10-20 queries per refresh to 2-3 if we do that join.