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