Is your MRI/IRES System running too slow?
Possible reasons include:
Network design - I can review your system architecture to verify that it is optimum for the MRI environment
Insufficient hardware - I can analyze your hardware utilization, figure out where your bottlenecks are and recommend specific upgrades which will improve your performance.
Poor report design - The MRI Application Toolkit is a very flexible program. Sometimes, reports are overly complicated and run way too long. In these cases, the reports can be rewritten using T-SQL in coordination with MRI's ATK for huge improvements. In one case, I rewrote a custom report which was running for 6 hours so that it would run in 6 minutes!
Poor SQL Index design - Sometimes customizations are made without consideration to SQL Indexes. Small changes to SQL Indexes have the potential of major speed improvements.