Closing Accounting Period / Year End - Speed

Closing accounting period + running year end on big data sets takes too long. (eg - Data set with c 500k Sales invoice per year takes 8-10 hours to run year end + Period end close/open accounting period on just sales ledger - c 2 hours) Needs to be quicker - Could function be offload to SQL procedure, rather than client side doing all the work??