This document covers performance for the overall Primavera Gateway configuration architecture. However, factors involved in the database setup play a very important role in performance. The following factors can impact database performance:
- Hardware architecture and operating system
- NIC (number of NICs, speed and duplex settings)
- Number of database instances on a server (dedicated versus shared)
- Disk storage system performance (I/O speed, buffer, mirroring)
- Table space layout and extent sizing
- Table data, index, and LOB distributions on table spaces
- Table and index fill factor definition
- Database block sizing
- Connection management (dedicated versus MTS)
- RAM allocations (automatic, SGA, PGA, shared pool, buffer pool)
- CBO optimizer parameter configuration setting
- Database table and index statistics gathering mechanism and frequency
- Anti-virus software
- Additional database jobs