Hi Janaka, Are you suggesting that this needs to be done for C4? Or is this e-mail FTR?
Thanks, Senaka. On Mon, Jul 16, 2012 at 3:40 PM, Janaka Ranabahu <[email protected]> wrote: > Hi All, > > I have noticed that the property handling in registry core is not done > properly. The ResourceDAO interface(which is the data access object for > resources) has only 2 methods which is related to properties and that is to > add properties and remove properties[1]. I have noticed that we call the > add properties method for both resource add and update operations. In other > words, for each add or update operation of a resource, we insert all its > properties again to the database. This behavior is there even if we turn > off resource versioning. > > IMO, this is an critical issue and it can lead to unnecessary database > growth. Also note that this causes unnecessary calls to the database too. > To insert a single property, we use 3 queries and because of that 3 > database calls happens. This number multiplies by the number of properties > for that resource. If we had 10 properties for a resource, the registry > core will do additional 30 database calls when the resource get > updated. Because of this reason, the REG_PROPERTY and > REG_RESOURCE_PROPERTY tables keep growing. > > Please note that this is one of the reasons why we see a performance > degradation when we connect to a remote database and do certain operations > like lifecycle management(since it uses properties to hold certain > information). AFAIK, most of our products use registry properties to store > various information and because of that this is a critical issue that needs > to be fixed. > > Thanks, > Janaka > > https://wso2.org/jira/browse/REGISTRY-870 > > [1] > https://svn.wso2.org/repos/wso2/carbon/kernel/trunk/core/org.wso2.carbon.registry.core/src/main/java/org/wso2/carbon/registry/core/dao/ResourceDAO.java > > -- > Janaka Ranabahu > Software Engineer > WSO2 Inc. > > Mobile +94 718370861 > Email : [email protected] > Blog : janakaranabahu.blogspot.com > > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- *Senaka Fernando* Member - Integration Technologies Management Committee; Technical Lead; WSO2 Inc.; http://wso2.com* Member; Apache Software Foundation; http://apache.org E-mail: senaka AT wso2.com **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 Linked-In: http://linkedin.com/in/senakafernando *Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
