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

hpd_4_0_postupgradecleanup.sql

This script removes product-specific tables that are no longer included in HPD 4.0. Data in these tables was migrated to updated tables during the upgrade process. The script can be run at any time after upgrade.

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

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