optimised loading (stopped whacky string appends, bunched the inserts
into blocks of 1000, forced mysql (and hibernate) to use the coomposite
index i made
screwed up updateRecord
heal up missing route_id, yuck