Glad to see others are looking at this, I’ve been made aware of another group that has been asked to handle 26k meals a day and they’ve just approached me for solutions. 
Looking forward to seeing the outcomes, it may be that this is immediately applicable within that other project and could save me a bunch of headache.