SQL Statements Grouped by Source

Previous Next

The source type of an SQL statement is the area of USoft Developer that this SQL statement is related to. A source type is one of the following:

•Constraint

•Domain Constraint

•Relationship

•System

•Authorization

•Interface

•Decision

•Job

•Action Task

•Export Task

•Import Task

•Job Task

•SQL Task

For SQL statements, the source type and source depend on the internal reason why the SQL Statement is executed. They will be calculated when saving a profile.

If a constraint causes the execution of an SQL statement, then the source type is Constraint. The same holds for the following source types (in which case, the source for the SQL statement is the name of the source that causes the execution of this SQL statement):

•Domain Constraint

•Relationship

•Decision

•Job

•Action Task

•Export Task

•Import Task

•Job Task

•SQL Task

If the internal Reason for an SQL statement is MANIPULATION or SEQNO, then the source type is System. If the internal Reason is AUTHORIZATION, then the source type is Authorization. In all other cases, the source type is Interface.

The SQL Statements Grouped by Source tab page on the Test Profiles window shows grouped information about the source types and sources that cause SQL statements to be executed. The advantage of this grouped information is that it gives a clear view of which source type and source causes performance problems.

Fields of the SQL Statements Grouped by Source tab page

Field

Meaning

Time

The total time of all SQL statements executed by this source.

Max Time

The maximum SQL execution time

#SQL

The number of SQL statements executed by this source.

Rows Manipulated

The number of records manipulated by all SQL statements executed by this source. It is he number of rows which have been updated, deleted and or inserted. This is the sum of the RowsProcessed in the execution elements list with the reason Manipulation.

Rows Retrieved

The number of records retrieved by all SQL statements executed by this source. It is the number of rows queried from the database or component. This is the sum of the RowsProcessed in the execution elements list with a reason other than Manipulation.

Source Type

The area of USoft Developer that this SQL statement is related to.

Source

The name of the domain constraint, the constraint, or the relationship that causes the execution of this SQL statement.

 

You can click the SQL Statements button to view the SQL statements within this source.