Symptoms
Reports are taking a long time to load
Diagnoses
13 processes that have about 204,000 workflows (mostly completed). And there are times where trying to go to the Process Overview from Workspace would take upwards of 5 minutes to load. The same issue occured with Reporting-related SmartObjects as well, they can take a few seconds to load a single record...Which is fine until runing a report with multiple records and it adds up.
Resolution
Installation of a new reporting dll for 4.6.10. Modification of customized queries that moved away from non-indexed columns speed up reporting considerably.