Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Samples and Examples
  4. Part 3: Tools and Utilities
  5. Part 4: SDK Resources

Database Performance Test

Database Performance Test

Informatica recommends that you load 20 to 100 million records to the database for the database performance test. Run the database performance testing utility to perform the operations to test the performance of the database.
The database performance testing utility performs the following operations:
  1. Creates a table.
    Creates a table with 25 columns. The data type of two of the columns is date. For a column of primary keys that contains IDs, the data type is integer. The data type of the other 22 columns is varchar. Also, few varchar columns have indexes.
  2. Creates and loads records.
    Creates and loads records to the database based on the value that you provide in the command line argument.
  3. Updates records.
    Updates one-fifth of total records or 200,000 records, whichever is lower on indexed and non-indexed columns. The update is based on the WHERE clause on the primary key column. The updates are performed by using 10 parallel java threads.
  4. Selects and deletes records.
    Selects and deletes one-fifth of the total records or 200,000 records. The deletes are performed by using 10 parallel java threads.
  5. Creates a table by using the
    CREATE TABLE AS SELECT
    statement, and then drops the first table.
  6. Drops the first table.
  7. Drops the new table that was created by the
    CREATE TABLE AS SELECT
    statement.
  8. Monitors the time taken for each operation.

0 COMMENTS

We’d like to hear from you!