Damitha, Can you profile GS server and verify why this is happening? Azeez
2010/12/3 Víctor Álvarez <spa...@gmail.com> > Hello, > i've made a simple login to the administration panel on Gadget server... > > on the mysql logs... there are more than 900 select querys exectued during > the login...you can see the log file. > > > you can see repeated selects : > > 15 times : > > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=1 AND REG_NAME IS > NULL AND REG_TENANT_ID=0 > > 8 times > SELECT REG_MEDIA_TYPE, REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, > REG_LAST_UPDATED_TIME, REG_VERSION, REG_DESCRIPTION, REG_CONTENT_ID FROM > REG_RESOURCE WHERE REG_PATH_ID=4 AND REG_NAME IS NULL AND REG_TENANT_ID=0 > > 15 times: > SELECT REG_PATH_ID FROM REG_PATH WHERE > REG_PATH_VALUE='/_system/config/repository/components/org.wso2.carbon.governance/configuration/services/service' > AND REG_TENANT_ID=0 > > 10 veces: > SELECT UM_ROLE_NAME FROM UM_HYBRID_USER_ROLE, UM_HYBRID_ROLE WHERE > UM_USER_NAME='victor.alvarez' AND > UM_HYBRID_USER_ROLE.UM_ROLE_ID=UM_HYBRID_ROLE.UM_ID AND > UM_HYBRID_USER_ROLE.UM_TENANT_ID=0 AND UM_HYBRID_ROLE.UM_TENANT_ID=0 > > 6 times: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=19 AND > REG_NAME='gadget-13' AND REG_TENANT_ID=0 > > > It shouldn't be normal to make this hard work over the myslq on every > simple login... > > I've checked too during the load of the main page of the gadget server, and > it produce hundreds of selects too... > > any idea? is this normal? > > Thanks in advance > > -- > Víctor Álvarez > Incoming IT www.incomingIT.com > www.twitter.com/incomingIT > Escribiendo en y sobre Accesibilidad Web: > http://accesibilidad.blogspot.com > > > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- *Afkham Azeez* Senior Software Architect & Senior Manager; WSO2, Inc.; http://wso2.com, * * *Member; Apache Software Foundation; **http://www.apache.org/*<http://www.apache.org/> * email: **az...@wso2.com* <az...@wso2.com>* cell: +94 77 3320919 blog: **http://blog.afkham.org* <http://blog.afkham.org>* twitter: **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez> * linked-in: **http://lk.linkedin.com/in/afkhamazeez* * * *Lean . Enterprise . Middleware*
_______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev