Previous Topic: Communicate What Is Going to RunNext Topic: Peak and Non-Peak Processing Times


Database Object ID Partitioning

The CSE installation and configuration no longer provides the user the option to create multiple Object ID partitions on the Encyclopedia Database. The option was originally added for page level locking, which was present in older versions of supported databases. For example, SQL Server. Since SQL Server now provides row level locking, multiple Object ID partitions are no longer necessary for any CSE database platform. The multiple Object ID partition option is not available at installation or configuration time however the feature is supported for the existing Encyclopedia database.

If your CSE does not contain many models you may still experience contention, but the contention should improve as more models are loaded to the CSE. You may also choose to define physical database partitions to help avoid contention (if your database supports this feature).

If you experience contention during the initial uploads, try single threading uploads until the database is sufficiently populated and then you can increase utilities.

If you are upgrading, your existing data remains the first partition, even if you increase the number of partitions.

Note: For additional information on Object ID partitions, see the Support Client online help.