Starting the Performance Inquiry
- Tabs: Across the top are four tabs that represent the four possible statuses for a report. Select a tab to display only those reports that have a matching status.
- Record Limit: This sets a maximum number of records that you want to view, starting with the most recent ones. If you change this number, the grid below will be refreshed accordingly and the new record limit will be saved for the next time you run this inquiry.
- Report Timings Grid: Here is a list of reports that match the status indicated on the Tab. You can select multiple rows on this grid if desired.
- Details Grid: The rows in this grid show additional details for the corresponding selected row(s) above.
- Comp: Company number.
- User: The Elliott User ID.
- Report ID: The full Report ID.
- Start Time: The time the report was started.
- Format: The output format of the report -- PDF, CSV or XLSX.
- Subreport: Indicates whether or not the report contains one or more subreports. Subreports require an additional SQL SELECT statement for each record in the main report and so can greatly increase the overall elapsed time of the report.
- Records: The number of records in the main report.
- Prep Time: The startup time for the report, including counting the number of qualifying records and calculating the optimal font size. All times in seconds.
- 1st SQL Time: The time to execute the SQL SELECT statement for the main report.
- Process Time: The time it takes to process through all records and subreports.
- Format Time: The time it takes to format the report. PDF takes longer than CSV and XLSX.
- Other Time: The amount of time left after subtracting all the other times from Total time.
- Total Time: The time between when the report starts and when it stops.
- Workstation: The Elliott Workstation value.
- Computer: The name of the computer from which the report was initiated.
- Login: The Windows login on the computer that ran the report.
- HelpID: The Elliott program from which the report was selected.
- SQL SELECT: The first SQL SELECT statement for the report -- it does not include any subreport SELECT statements.
- More Information: Additional information in XML format that specifies the connection string, the destinations, any exceptions encountered, etc.
You will see a summary line (second red rectangle) that provides the average record count, SQL time and total time for that report.