Id as Strings in Activiti Engine on Performance

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

davanna

Hi Members,

I see that all the ids used in the engine are stored in db tables as varchar. Is there any specific reason for it. Is it not a performance issue as these ids are numbers and could have stored as BigInt in the database. Can you clarify ?

Thanks

jbarrez

The reason is because we've got flexible id generators, for example one that supports UUIDs.
In the past years, having a string as id has never been a cause for performance problems.