[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[Mark Norton]

May, Megan Marie wrote:
> Would you be willing to share those situations you've used it?
>   
Some time ago, I was asked by a client to make some rather extensive 
changes to the Sakai portal.  Most of these changes where layout and 
could be handle in CSS and Velocity templates.  A few changes required 
new flags and state data to be associated with a course site.  Custom 
tools were proposed to take advantage of this new data with the 
requirement that other, existing Sakai tools continue to work.  Site 
properties was the simplest (and most economical) way to implement this 
capability.

After many months of design, discussion and evaluation, the client 
decided not to use Sakai and went off on another path.  Had they chosen 
to stay, site properties would have been highly useful in implementing 
the design.

- Mark
> 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"
>>
>>   
>>     
>
>
>