Reports: Slow Server Response

Common causes of slow running reports

1. Returning too many results
   1. Too many fields report on
   2. Fields could be calculated field that apply a GlideRecord Query
2. Grouping by fields non-indexed field
   1. Duration or Name
3. Reporting on a user-created table with many joins to other tables

What causes a homepage to load slowly?

• Most likely just too many results
• Multiple join to another table
• Verify the type of report
• What data is being examined

One of the most common reasons for poor homepage performance are reports that return too many results or reporting on a user-created table that has multiple joins to another table. If you cannot find any of the common causes, carefully examine the type of report and what data is being collected.