Progress
Database Administration
Guide and Reference


Optimizing Data For Sequential Access

If users repeatedly request data from the same tables in a determined order (for example, to create a certain report), dump and reload the data to optimize it for sequential access. Loading tables in order of average record size results in the most efficient organization of records for sequential access.

Follow these steps:

  1. Use PROUTIL with the TABANALYS qualifier to determine the mean record size of each table in the database. See "Database Administration Utilities," for a deatiled description of the PROUTIL TABANALYS qualifier.
  2. Dump the definitions and data.
  3. The Data Administration and Data Dictionary tools dump in order of primary index. If you access the records by another index, dump the data by that index. Use a Progress 4GL procedure similar to the following to dump the data by the index of your choice:

    OUTPUT TO table-name.D. 
    FOR EACH table-name BY index 
    EXPORT table-name. 
    END 
    

    This procedure creates a contents (.d) file organized by order of access.

  4. Load the tables of less than 1,000 bytes first, in order of average record size. Use the Data Dictionary or the Data Administration tool to load data one table at a time, or use the Bulk Loader utility and a description file to control the order.
  5. If you use the Bulk Loader, the order of the fields in the description file must match the order of the fields in the data file. If they do not match, the Bulk Loader attempts to load data into the wrong fields.

  6. Load the remaining, larger tables, in order of average record size.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095