[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[May, Megan Marie]

Hi Mark, 
    Rest assured, my question had no intent behind it.   Stephen mentioned that they had 7 records and since IU had 0 I was interested in knowing what it was used for/could be used for.  

Would you be willing to share those situations you've used it?   
Megan 


-----Original Message-----
From: Mark Norton [mailto:markjnorton at earthlink.net] 
Sent: Friday, August 28, 2009 9:56 AM
To: May, Megan Marie
Cc: Stephen Marquard; Joshua Swink; sakai-dev
Subject: Re: [Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

May, Megan Marie wrote:
> Does anyone know the purpose of this query and associated table?  At IU we have 0 records in this table.  
>   
Since the Site class extends Entity, and entities support arbitrary 
properties to be associated, my belief is that this table implements 
persistent storage of site properties.  However, all of the important 
properties of a site (like title, for example) are handled in other 
ways.  This table preserves the opportunity to save other kinds of data 
for a site.  The fact that IU has no records in it just means that they 
are not using any tools that take advantage of this mechanism.

It is my belief that very few tools, if any, that make use of this 
capability.  However, I have been faced with situations where it would 
be a lifesaver.  As such, just let it be.  An emtpy database table does 
IU no harm.

- Mark Norton
> ~ Megan 
>
> -----Original Message-----
> From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Stephen Marquard
> Sent: Thursday, August 27, 2009 2:11 PM
> To: Joshua Swink
> Cc: sakai-dev
> Subject: Re: [Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?
>
> You can increase the TTL and cache properties in sakai.properties, e.g.
>
> timeToLive at db.cache.SAKAI_SITE_PAGE_PROPERTY=3600
> timeToIdle at db.cache.SAKAI_SITE_PAGE_PROPERTY=3600
>  
> but looking at our production db, I see hardly anything in that table - only 7 records with the property "is_home_page". 
>
> Cheers
> Stephen
>
>   
>>>> Joshua Swink <joshua.swink at gmail.com> 8/27/2009 8:06 PM >>> 
>>>>         
> I haven't inspected our database, but Sakai says this:
>
> org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY:
> count:2993 hits:9838 misses:732554 hit%:1
>
> That seems to be a very low hit rate. Would it be helpful to increase
> the size of the cache? How can I do that?
>
> Josh
>
> On Thu, Aug 27, 2009 at 11:01 AM, Stephen
> Marquard<stephen.marquard at uct.ac.za> wrote:
>   
>> There is a cache for that (along with other property lookups) - c/f SAK-13886
>>
>> Have a look in Admin Workspace / Memory / Status and see what it says on one of your app servers, e.g. on a newly started trunk build I see something like:
>>
>> org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY: count:40 hits:3 misses:51 hit%:5
>>
>> Perhaps you have this cache disabled in your config.
>>
>> Cheers
>> Stephen
>>
>>     
>>>>> "Maurer, Christopher Wayne" <chmaurer at iupui.edu> 8/27/2009 7:52 PM >>>
>>>>>           
>> 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"
>>
>>     
>
>
> _______________________________________________
> 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"
> _______________________________________________
> 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"
>
>