Product Home
DTM Data Generator Online Documentation
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Execution
Fill Table
Table Fill Modes
Table Fill Options
Row count management
Fill Methods
Method options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Field groups
Data Preview
Table Information
Advanced
Data Rule Properties
Project Properties
Tables Selection
Program Settings
File Structure
Values Library
Clear Rule
Project migration
Command Line
Performance Tips
Schema Viewer
Format Strings
Tables Creation Options
Select column
Objects Creation
Data export
How to...
Tools
Random BLOB Loader
Values Library Builder
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Performance tips

Use the 'unique' property of fields only when you really need it. The best alternative will be to create a unique index if you need the uniqueness of field values.

If possible, delete indexes and disable triggers for the table where test data will be inserted. After you add the necessary data, restore the previous state.

Very large lists of values (including those loaded from files) can considerably reduce the performance and require a considerable amount of memory.

Controlling the number of records inserted within one transaction will allow you to have the acceptable size of the transaction log and achieve the best DBMS performance.

Use -p command line switch or "default mode is Performance" in Settings. Please select this option with checked projects only.

See also: Performance issues and selecting optimal rules in DTM Data Generator.