eva/3 Application BuilderDeveloping eva/3 ApplicationsWorking with DatabasesDatabase Performance Test 

Usage

Select one or several connections in the data base view, which should be tested, and select Performance from the context menu.

Fig. 60: Database Performance Test - Menu
Fig. 60: Database Performance Test - Menu

In the following dialogue (s. fig. 61 ) the settings for the performance test can be made.

Fig. 61: Database Performance Test - Settings
Fig. 61: Database Performance Test - Settings

The following settings are available:

Testproperties
Finished datarecords Number of data records, which are written into the test table
Scale distance Determines the distance of the measure. E.g. a value of 1000 will alwais create a measure point after 1000 data records or ms depending on the choosen test type
Test type As test type the write test or the write/read test can be selected
View properties
View
Splinecurve: A spline curve is a curve that passes by a given number of points, and connects them smoothly
Pointline: The measure points are connected directly
Splinekurve & Punktlinie: Spline curve and point line are shown together
Execution
t/ms per data record: Measures the used time for the data recordes given at Scale distance in ms
Data records per time Measures the written data records for the time given at Scale distance
Multi selection
Note: The following points are only selectable, when at least two databases are choosen for the test
Processing
Parallel: The write/read test is executed at the same time for the selected data bases
Successively: The write/read test is successively executed for the selected data bases