At development time there should be an error or warning given when the length of a primary key field exceeds the documented limit of 500 bytes.
- when analyzing the entity definitions (Analyze Model) the primary key length and length of indices should be checked against the allowed maximum (500bytes).
Primary keys (PK) >500bytes can cause severe problems at runtime. We have customer reports that database clients are crashing and uservers hang indefinitely when trying to retrieve data via the PK where the PK >500 bytes. This should be caught during development, it is difficult to track down and fix at runtime.