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