topic Re: Question on underlying storage of metadata in Alfresco Archive

Question on underlying storage of metadata

orichaud — Wed, 26 Jan 2011 15:45:12 GMT

I am trying to understand on Alfresco can behave in certain circumstances.For this, I have created a dummy data model with a single type containing 1,000 properties. And a webscript is in charge, with the Java API on top of the node repository, to fill instances of this type.After creating thousands

Re: Question on underlying storage of metadata

mrogers — Wed, 26 Jan 2011 16:00:10 GMT

Yes the alf_node_properties table does get rather large. However alfresco anticipates that so it should not be a problem.
There are instances of alfresco with an order of magnitude more data than yours working just fine.

Cache tuning is always a bit of an art, but yes it does work and makes a fairly significant difference.

After deleting your nodes they were probably moved to the archive store (its a soft delete) As and when you get rid of the nodes then the properties will be removed from the alf_node_properties.

Re: Question on underlying storage of metadata

orichaud — Wed, 26 Jan 2011 16:08:27 GMT

Thanks for you answers.

How many rows make the difference? I mean, 10 millions or more?

You did not answer to one of my questions: having so many properties for a node (more than 1,000), are we going to kill alfresco?

Regards.
Olivier