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

[Aaron Zeckoski]

If you are using mysql you will probably want to enable the query cache
which will help avoid this kind of thing running multiple times.

It is worth noting we are looking at site caching in the kernel in general
right now so this is a known issue.

-AZ


On Wed, Feb 23, 2011 at 3:57 AM, Rajesh Kumar K P <
rajeshkumarkp at aims.amrita.edu> wrote:

>  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 <A.M.Berg at uva.nl>
> *To:* Rajesh Kumar K P <rajeshkumarkp at aims.amrita.edu>
> *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
>
> 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
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>



-- 
Aaron Zeckoski - Software Engineer - http://tinyurl.com/azprofile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110223/0493531e/attachment.html