In reply to Lewis Cowles (@LewisCowles1).

Those are really non issues. If you have such a big scale site and need reporting, run it on its DB backup/replication. which you need to have in any case.

Front end users are absolute priority and you should design you DB structure and caching to serve them best, but reporting? as long it is reasonable time, who cares how much time it takes so give less priority for reporting even if it means it will take 10 min instead of 1.