Need to start using transactions in show population code (speed up the calendar)

testing with a full schedule no end on all shows, 24 shows a day (1 hour each)
is very slow when the calendar has to populate the events before displaying them, on month view can take 14-18 seconds just for the request to complete, this doesn't include event rendering time.


-- too much time is being spent doing separate commits to the db, there is a lot of room for errors during this time as well as conflicts could happen while db is not in a completed state.