commit changes to reduce number of admin queries created when viewing