Side thought here:
With the coming changes to notifications, and the ability to disable production notifications… I don’t know how many IOPS to the database production orders cause relative to the entire game. It’s probably a lot, and I would expect this number to go up potentially by as much as an order of magnitude.
Most people run huge production orders to cut down on notifications. I personally commonly target an overall time in the 2-4 day range, with quantities of 5-20x. But - now that we’ll be able to disable them, I expect most people will revert to small production runs. This means a TON more writes to the database compared to what we’re seeing now. I personally plan on running minimum production order sizes to make my logistics more consistent.
I guess… just make sure to take into account the performance implications on the database server. It’s probably going to be significant.