On Sat, Dec 4, 2010 at 10:10 AM, Afkham Azeez <[email protected]> wrote:
> Damitha, > Can you profile GS server and verify why this is happening? > +1. Thanks, Senaka. > > Azeez > > 2010/12/3 Víctor Álvarez <[email protected]> > >> 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 >> [email protected] >> 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: **[email protected]* <[email protected]>* 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 > [email protected] > https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- *Senaka Fernando* Associate Technical Lead & Product Manager - WSO2 G-Reg; 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://www.linkedin.com/in/senakafernando *Lean . Enterprise . Middleware
_______________________________________________ Carbon-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
