topic Re: proc_inst_I'd_ column being string in database in Alfresco Archive

proc_inst_I'd_ column being string in database

kethur — Tue, 12 May 2015 04:33:33 GMT

Hi,I always wonder why this column is defined as varchar and not as number in the database? Same thing with execution id.ThanksRaj

Re: proc_inst_I'd_ column being string in database

trademak — Wed, 13 May 2015 12:25:43 GMT

Valid point, with the default db id generator it's always a number, but we also allow the id generator to be overridden. And then it could contain text characters as well.

Best regards,

Re: proc_inst_I'd_ column being string in database

kethur — Wed, 13 May 2015 15:25:24 GMT

Thanks. Is there any added benefit of allowing characters for this column. I am sure it adds to database query performance a lot especially when looking up instance ids in a large process database. Looking for set of variables for a process instance id is an example of that.

Any plans to change it in future?

Raj

Re: proc_inst_I'd_ column being string in database

jbarrez — Mon, 18 May 2015 15:07:41 GMT

> I am sure it adds to database query performance a lot

I'm, sure that in this day databases are fast enough not care about a few characters. After all, all those id's are indexed.
There are multiple places where we can tweak performance in Activiti before having to resort to these kind of things.