Ways to use query information
A useful way to view query information in Guidewire Profiler is to use the column header sort functionality to look for the top few queries in the following areas.
- Avg Time
- Look for the individual queries that took the longest average time.
- Total Time
- Look for the individual queries that took the longest cumulative time.
- Total Rows
- Look for the individual queries that contain a large number of rows, which indicates a large amount of processing.
- Avg Rows
- Look for a query with one or more executions with a row count of 1000 (or a similar
round number). Then, look for another query with seemingly identical SQL and the same
stacks but with a different value for the row count. In most cases, the two queries are
the same query. However, the profiler treats the two queries differently as the queries
have a different number of arguments (indicated by a ? in the reported SQL statements).
Typically, the row numbers differ because the
INorWHEREclause for the query retrieves 1000 rows at a time and thus the row total equals 1000. The query then retrieves the remainder of the rows, which is less than 1000.