To set database properties that optimize database performance

About this task

You can set database properties to optimize database performance and to reduce database size. Set database performance properties by opening the Database Properties box on an existing database or as you create a database.

Make sure you fully understand these database properties before changing their settings.

Procedure

  1. Make sure you have Designer or Manager access in the database ACL.
  2. Do one of the following:
    • Open a database and choose File - Application - Properties.
    • As you create a new database, click the Advanced button.
  3. Select or deselect properties listed in the table that follows.
  4. After you select any of these three properties, compact the database for the property to take effect:
    • Don't maintain unread marks
    • Optimize document table map
    • Don't support specialized response hierarchy

Results

Tip: You can use the compact task with specific options to enable or disable the preceding three properties and then compact the database.

Property

Tab

To optimize performance/size

Improves database performance?

Reduces database size?

Allow use of stored forms in this database

Basics

Deselect option

Yes

Yes

Display images after loading

Basics

Select option

Yes

No

Don't maintain unread marks

Advanced

Select option

Yes

Yes

Optimize document table map

Advanced

Select option

Yes

No

Don't overwrite free space

Advanced

Select option

Yes

No

Maintain LastAccessed property

Advanced

Deselect option

Yes

No

Don't support specialized response hierarchy

Advanced

Select the option

Yes

Slightly

Don't allow headline monitoring

Advanced

Select the option

Prevents performance degradation

No

Limit entries in $UpdatedBy fields

Advanced

Select the option and specify the number of entries $UpdatedBy fields can contain

Yes

Yes

Limit entries in $Revisions fields

Advanced

Select the option and specify a limit on the number of entries $Revisions fields can contain. The suggested limit is 10 entries.

Yes

Yes