Manipulations

Previous Next

The Manipulations tab page on the Test Profiles window shows statistical timing information about all manipulations in the profile.

Only the manipulations with Constraint, Relationship or Interface source type can occur.

Fields of the Manipulations tab page

All times are in milliseconds:

Field

Meaning

Manipulation Seqno

The sequence number of the manipulation.

Time

The execution time of the single manipulation

Total Time

The total execution time used for performing data manipulations, including related manipulations.

SQL Time

The time used for executing all SQL statements within a single manipulation.

Total SQL Time

The total time used for executing SQL statements, including SQL statements in related manipulations.

#SQL

The number of SQL statements within a single manipulation.

Total #SQL

The total number of SQL statements within the manipulation, including SQL statements within related manipulations.

Source Type

The area of USoft Developer that this manipulation is related to.

Source

The name of the domain constraint, the constraint, or the relationship that causes this manipulation.

Manipulation

The type of data manipulation, for example: Update or Insert.

Table

The database table that is affected by this manipulation.

 

From the Manipulations tab page, you can:

Click the View Manipulation button to view a specific manipulation.

Click the Manipulations Started button to view all manipulations started due to SQL Statements within a specific manipulation.

Click the SQL Statements button to show the SQL statements within a specific manipulation.