AnsweredAssumed Answered

Question on underlying storage of metadata

Question asked by orichaud on Jan 26, 2011
Latest reply on Jan 26, 2011 by orichaud
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 of instances of this custom type, the alf_node_properties has grown below several millions rows.
- Will it have an impact on performances?
- Does the cache will still work with such big objects in memory? Does it still really work?

After deleting nodes (call to the deleteNode method), I noticied no change in the alf_node_properties table? Can I force the real deletion of rows connected to deleted nodes?

The rationale for doing this is to be able to store document made of several hundreds of properties distributed in sub nodes connected by child association. Are we not misusing Alfresco?
With such an approach, what will be the behaviour of the form engine? Will it be able to still work ro do we have to look for something more appropriate?

Thanks a lot for your reply and any advice.