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.