Optimized access to data

The use of sequence cache and separate table spaces for large tables can help you improve your system performance. Also, you can set applicable page sizes and storage capacities to these table spaces and cache memories for optimal performance.

Table spaces

A database administrator can use the following guidelines for table space page sizes. The administrator then moves the tables that include the most record types and are the most heavily used into table spaces with these page sizes:
Table 1. Guidelines for table spaces page sizes
Page size Row size Column count limit Maximum capacity (DMS table space)
4 KB 4005 500 64 GB
8 KB 8101 1012 128 GB
16 KB 16293 1012 256 GB
32 KB 32677 1012 512 GB
Separate indexes from the data and place them into a different table space. Use the Database Configuration application to move the indexes. Also, separate large tables, such as Assets and Work Orders, into their own table spaces for optimal performance.

Sequence cache

Sequence caches are used to automatically generate unique values in the database. These values are typically used as identifiers for columns or rows. Set the maxseq sequence for the rowstamps column to 500 because this column frequently requires values. Set the cache size for all other sequences to 50.


Feedback