Creating a Database for Performance Testing

The following topic describes how to create large TrackStudio databases to use as benchmarks.

Use massive to generate a large database with the necessary configuration and structure. You can use this database to check the TrackStudio performance rate for that database and your hardware. Massive is supplied with TrackStudio SA only.

To prepare a database:

Edit massive/default.properties to configure test database
Execute

Copy Code

> massive/massive

To create a test database:

Run TrackStudio Server Manager (sman).
Select the Database -> Database Connectivity tab.
Enter the JDBC connection properties of the empty database (without any tables).
Select the Database -> Database Management tab.
Enter the generated XML file name
Click the Create Database button.

When you run TrackStudio for the first time, it indexes all tasks for full text search. The process of indexing can take several hours. If you are not going to use full text search, you can skip the indexing process. To do this before running TrackStudio, create the file skipindex.flag in the directory that is specified in the trackstudio.indexDir parameter in trackstudio.properties.

To login as an administrator, use login=root, password=root. Other users have logins of the following type: user2, user3, etc and password root.

Topic path: Installation Guide > Creating and Managing the Database > Creating a Database for Performance Testing