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

Rajesh Kumar K P rajeshkumarkp at aims.amrita.edu
Tue Feb 22 23:32:30 PST 2011




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

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


More information about the sakai-dev mailing list