topic Id as Strings in Activiti Engine on Performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/id-as-strings-in-activiti-engine-on-performance/m-p/228319#M181449 <HTML><HEAD></HEAD><BODY><SPAN>Hi Members,</SPAN><BR /><BR /><SPAN>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 ?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /></BODY></HTML> Tue, 17 May 2016 19:52:27 GMT davanna 2016-05-17T19:52:27Z Id as Strings in Activiti Engine on Performance https://connect.hyland.com/t5/alfresco-archive/id-as-strings-in-activiti-engine-on-performance/m-p/228319#M181449 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 Tue, 17 May 2016 19:52:27 GMT https://connect.hyland.com/t5/alfresco-archive/id-as-strings-in-activiti-engine-on-performance/m-p/228319#M181449 davanna 2016-05-17T19:52:27Z Re: Id as Strings in Activiti Engine on Performance https://connect.hyland.com/t5/alfresco-archive/id-as-strings-in-activiti-engine-on-performance/m-p/228320#M181450 <HTML><HEAD></HEAD><BODY><SPAN>The reason is because we've got flexible id generators, for example one that supports UUIDs.</SPAN><BR /><SPAN>In the past years, having a string as id has never been a cause for performance problems.</SPAN></BODY></HTML> Wed, 18 May 2016 16:49:00 GMT https://connect.hyland.com/t5/alfresco-archive/id-as-strings-in-activiti-engine-on-performance/m-p/228320#M181450 jbarrez 2016-05-18T16:49:00Z