You are here

Database considerations

Large repositories require some additional consideration during an upgrade, such as optimization of the database and adding optional indices to the database for metadata queries.
Two important aspects to consider when upgrading a large repository are:
  1. Transactional metadata query is a feature that requires the creation of new indices. For large repositories, this process may take a long time. See Transactional metadata query for more details.
  2. After restoring the production data of large repositories and creating the indices, refer to Database validation - Maintenance and Tuning to ensure optimal performance.

    After applying the patches, check that the logs show no warnings or issues with the database. If the indices could not be created, some queries may run very slow.

Sending feedback to the Alfresco documentation team

You don't appear to have JavaScript enabled in your browser. With JavaScript enabled, you can provide feedback to us using our simple form. Here are some instructions on how to enable JavaScript in your web browser.