Optimizing the product library

When implementing the Nautical Solution in an organization, there are several ways to maintain your system so that performance is not degraded over time.

The product library database is less likely to be a source of poor performance since less database transactions occur than in the NIS database. However, the same database maintenance rules apply. Even though the product library has significantly fewer rows, it can store product geodatabases (MDF files) within the database and often require more disk space than the NIS.

The following is a list of tasks the ArcSDE administrator should do to the product library database:

  1. Start ArcCatalog.
  2. Delete all versions by performing the following steps:

    There should not be any version other than DEFAULT on a production product library.

    1. Right-click the database connection in the Catalog Tree window and click Versions.

      The Version Manager dialog box appears.

    2. Right-click a version other than the DEFAULT version and click Delete.
    3. Click Yes on the Delete Version message box that appears.
    4. Repeat steps 2b–2c for any other versions that are not the DEFAULT version.
    5. Close the Version Manager dialog box.
  3. Right-click the product library database and click Administration > Compress Database.
  4. Click Yes on the Confirm Compress dialog box that appears.
  5. Right-click the database and click Administration > Geodatabase Maintenance.

    The Geodatabase Maintenance dialog box appears.

  6. Check the Analyze, Rebuild all indexes, and Shrink geodatabase check boxes.
  7. Click OK.
  8. Close ArcCatalog when maintenance is finished.