User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Performance Test
Transaction SYSPER
This transaction allows a performance test of the technical platform to be carried out on a DOKA installation. This involves the testing of the various technical components within the installation. For more details re. performance of TradeDesign based applications see Performance in TradeDesign Software or Performance Analysis.
- Database access operations
- Database access operations, read and write
- String operations
- File transfer from server to client and vice versa
- Arithmetic operations
The following actions must be performed prior to running a performance test:
- Create table TST with transaction SYSDBA. It only needs to be created once and will then be available for every subsequent test run.
- Enter the INR of an existing record in the TRN table
- Enter the INR of an existing record in the USR table
- Enter a date for a Range Select
- Enter the number of cycels the individual tests are to be run
The various tests are:
| Step | Description | Comment |
|---|---|---|
| 1 | DBRead in TRN table | Selection of all columns based on INR with bind |
| 2 | DBExecutesql in TRN table | Selection of all columns based on INR without bind |
| 3 | DBExecutesqlVar in TRN table | Selection of all columns based on INR with bind |
| 4 | DBRead in USR table | Selection of all columns based on INR with bind |
| 5 | DBExecutesql in USR table | Selection of all columns based on INR without bind |
| 6 | DBExecutesql in USR table | Selection of NAM column based on INR with bind |
| 7 | DBReadHold / DBFree in USR table | Selection of all columns based on INR with bind |
| 8 | DBInsert in LCK table | DBCommit at the end |
| 9 | DBInsert in LCK table | DBCommit after every record |
| 10 | DBCommit | |
| 11 | DBExecueSQl( “Commit” ) | |
| 12 | DBRead in XRT table | Range Read with fixed date in XRT table for CUR = 'EUR' |
| 13 | DBRead in XRT table | Range Read with variable date in XRT table for CUR = 'EUR' |
| 14 | DBRead in XRT table | Range Read with variable date in XRT table for CUR = 'EUR' with bind |
| 15 | SDBInsert in TST table | DBCommit at the end |
| 16 | SDBInsert in TST table | DBCommit after every record |
| 17 | DBInsert in TST table | DBCommit at the end |
| 18 | DBInsert in TST table | DBCommit after every record |
| 19 | Text concatenation | 250,000 times attachment of 4 bytes |
| 20 | Streamsave | 10,000 times size 1 MB |
| 21 | Streamload | 10,000 times size 1 MB |
| 22 | Filecopy from server to client | 20 times 1 MB |
| 23 | Filecopy from client to server | 20 times 1 MB |
| 24 | Filecopy from server to client | 1000 times 1 byte |
| 25 | Filecopy from client to server | 1000 times 1 byte |
| 25 | Arithmetic operations | 2,000,000 times calculation using addition, subtraction, multiplication and division |
Transaction Panels
Performance Test
Datafields
