topic Re: Alfresco data base size and versionedProperty qname in Alfresco Archive

Alfresco data base size and versionedProperty qname

amar — Tue, 18 Mar 2008 17:42:43 GMT

Hi,I have a repository with 180 000 objects : (spaces and documents), when I select nodes in the table alf_node I have 2 300 000 records, i have 180 000 records with my custom type_qname and remainig records ( more than 2 000 000) with versionedProperty in the type_qname field.I have one version for

Re: Alfresco data base size and versionedProperty qname

acis — Fri, 04 Apr 2008 15:15:18 GMT

versionedProperty is the frozen value of a property of a version node. so if you have a type with 20 properties, each time you create a version of a node from that type, you'll have 20 versionedProperty created en alf_node

Re: Alfresco data base size and versionedProperty qname

dwilson — Wed, 23 Jul 2008 23:55:38 GMT

OK, so in my case I've got in total around 100 pieces of metadata for each piece of content in my custom model- so I'm going to have two orders of magnitude more rows in the DB if I have versioning turned on?

Is there any way to version the content but not the properties- in other words prevent the versionedProperty node from being stored every single time?

At this point we're even considering the work-around of adding a changelog textbox as a 101st metadata item. :shock:

Thanks for any help!

Re: Alfresco data base size and versionedProperty qname

acis — Mon, 18 Aug 2008 08:10:15 GMT

I didn't try to change the versioning process so I can't tell you if you can disable versioned properties.