[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTY table in 2.6?

Tom Helmer Hansen thelmer at ruc.dk
Thu Aug 27 10:56:20 PDT 2009


Hi Cristopher

We had some problems with the autoddl for this table (amd one more 
related). It was something with mysql not supporting double length keys.

Tom

Maurer, Christopher Wayne wrote:
> Looking at some of our database reports, we see that in the time span 
> of an hour the following query gets run over a million times:
>
> select NAME, VALUE from SAKAI_SITE_PAGE_PROPERTY where ( PAGE_ID = ? )
>
> Rumor has it that this is probably for the internationalization of 
> page/tool titles, is that right?
>
> Are other folks running 2.6.x seeing similar things?  Should we be 
> concerned about how often this query is being run?
>
> Chris
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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"

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


More information about the sakai-dev mailing list