For the most part, COmanage Registry does not need specialized tuning for larger deployments (10k+ records). However, there are a few things to keep in mind:

  • Newer versions of PHP perform better. Use PHP 7+.
  • The best way to load large amounts of data is via Organizational Identity Sources. The REST API v1 is not currently optimized for bulk operations.
  • When using Organizational Identity Sources with MySQL as the Registry database, it may be necessary to run a manual analyze table to resolve a slow query issue (CO-1406):

    mysql> analyze table cm_org_identity_source_records;

    Postgres does not appear to have this problem.

  • As the number of records increases, the database work to maintain indices also increases, and so write operations take longer.
  • No labels