[Building Sakai] query is executing multiple times when user login

[Rajesh Kumar K P]

Dear Alan,

          I have monitored the situation as follows :

                     1) Downloaded the Sakai 2.6.1 binary version with build-in tomcat (and changed the DB to MySQL 5.0.19)

                     2) Enabled MySQL Query Logging (in my.cnf)

                     3) While checking the login process of 1 user, i found that the query is fired repeatedly (around 5-7 times for me) 

         we are able to reproduce this situation in other test servers also.

       kindly guide me how to avoid these repeating quries 

With Regards
Rajesh


  ----- Original Message ----- 
  From: Berg, Alan 
  To: Rajesh Kumar K P 
  Cc: mt at collab.sakaiproject.org 
  Sent: Wednesday, February 23, 2011 1:24 PM
  Subject: RE: [Building Sakai] query is executing multiple times when user login


  Hi Rajesh,

  I find this a significant and I suspect long standing issue. I was wondering how you monitored the situation.



  Alan

  Alan Berg
  QA Director - The Sakai Foundation

  Senior Developer / Quality Assurance
  Group Education and Research Services
  Central Computer Services
  University of Amsterdam

  http://home.uva.nl/a.m.berg

------------------------------------------------------------------------------

  From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Rajesh Kumar K P [rajeshkumarkp at aims.amrita.edu]
  Sent: 23 February 2011 08:32
  To: sakai-dev at collab.sakaiproject.org
  Subject: [Building Sakai] query is executing multiple times when user login





  Dear sir 

        I configured sakai in linux enviornment with sakai . Iam using databse as MYSql 5 . When a single user is log into the system . i find out that single queries is executing multiple times for a single user 
  example queries like 

  select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID = SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = '75a06e85-dc6f-4f3b-8418-00cb890a869c' and SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE ASC 

  kindly guide me how to avoid these repeating quries 


  With Regards

  Rajesh

             
                    -----------------------------------------
                    Amrita Institute Of Medical Sciences & Research Centre, Cochin, India 
                   
             
              Amrita Institute of Medical Sciences & Research Center. Amrita Lane; AIMS Ponekkara P.O; Kochi-682041. Kerala, South India. 
              Tel: +91 484 2801234,2851234,4001234 Fax: +91 484 2802020 Email: admin at aims.amrita.edu Web: www.aimshospital.org 
             
       


---------------------------------------------------------------------
Amrita Institute Of Medical Sciences & Research Centre, Cochin, India

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110223/a00e9e20/attachment.html