topic Creating custom model with Metadata in community in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/creating-custom-model-with-metadata-in-community/m-p/248212#M201342 <HTML><HEAD></HEAD><BODY><SPAN>We are using alfresco community 3.4 and have a requirement to store 50000 files yearly , we have&nbsp; created our custom model with 15 fields as meta data , Does this cause a performance issue ?</SPAN><BR /><SPAN>Should we descrease the number of meta data fields for better performance.</SPAN></BODY></HTML> Wed, 22 Jun 2011 09:01:50 GMT kamal1387 2011-06-22T09:01:50Z Creating custom model with Metadata in community https://connect.hyland.com/t5/alfresco-archive/creating-custom-model-with-metadata-in-community/m-p/248212#M201342 We are using alfresco community 3.4 and have a requirement to store 50000 files yearly , we have&nbsp; 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. Wed, 22 Jun 2011 09:01:50 GMT https://connect.hyland.com/t5/alfresco-archive/creating-custom-model-with-metadata-in-community/m-p/248212#M201342 kamal1387 2011-06-22T09:01:50Z Re: Creating custom model with Metadata in community https://connect.hyland.com/t5/alfresco-archive/creating-custom-model-with-metadata-in-community/m-p/248213#M201343 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Thu, 23 Jun 2011 01:43:19 GMT https://connect.hyland.com/t5/alfresco-archive/creating-custom-model-with-metadata-in-community/m-p/248213#M201343 jjaquette 2011-06-23T01:43:19Z