09:56 < mdxi> holy cocks
09:56 < mdxi> everytime i think i've seen the worst, the old codebase here vomits up a new horror
09:56 < mdxi> the databases here are in -14th normal form
09:57 <@ejp> ha
09:58 < mdxi> we provide movie data to our stations. we get this data from a Tribune media feed. it is processed nightly.
09:58 < mdxi> it is processed by *12* cron scripts which run over a span of seven hours
09:58 <@ejp> o_O
09:58 < mdxi> the movies table has a field for "rating", which doesn't have the rating in it
09:58 < mdxi> tha rating is in the showtimes table
09:58 < mdxi> along with the rating description
09:59 < mdxi> so, we store this string: Parents Strongly Cautioned
09:59 < mdxi> 126,000 times
09:59 <@ejp> XD
09:59 < mdxi> Parental Guidance Suggested a paltry 65,000 times