Creating custom model with Metadata in community

[kamal1387]

We are using alfresco community 3.4 and have a requirement to store 50000 files yearly , we have  created our custom model with 15 fields as meta data , Does this cause a performance issue ?
Should we descrease the number of meta data fields for better performance.

[jjaquette]

Every property will equate to a new row in alf_node_properties for each piece of content, so 15 properties will be 15 additional rows for each item. Multiply that by 50000/yearly, you get a large table. That being said, this is not uncommon and just make sure to tune your db and pool appropriately.