Runtime efficiency of the PPM server system, and especially the import largely depends on the database system.
Please observe the following performance-related instructions for your PPM system:
Monitor the runtime configuration of the database instance in frequent intervals and, if required, adjust the configuration if you see room for improvement.
Frequently update the database statistics.
After aggregating or deleting a large number of process instances, reorganize the tables and recalculate all database schema indices.
The runppmimport command line tool supports you in recalculating the indices. Indicate the argument -index new, e.g.:
runppmimport -client <client name> -user system -password <password> -index new
If at all possible, do not interrupt this procedure to avoid time-consuming consolidation processes in the database schema.