CARIS HPD : Database Administration : Upgrading a Schema : After Upgrading : Schema Optimization
 

Schema Optimization

Additional scripts can be run after installation. These scripts optimize space and performance and can be run at any time that there is a noticeable loss in overall performance. All scripts are optional.

Script

Description

optimize_space.sql

This script completes the deletion of any products and projects that were previously deleted. It can be run periodically after the upgrade

Location: C:\ProgramData\CARIS\HPD\<version>\Server\admintools

optimize_performance.sql

This script optimizes some spatial indexes and locking information. It can be run periodically after the upgrade

Location: C:\ProgramData\CARIS\HPD\<version>\Server\admintools