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.
  • As of Registry v3.3.0, BulkLoad Shell is also an option. BulkLoad Shell currently only supports Postgres.
  • For a further discussion of available options, see Bulk Initial Data Loading.

• 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.