[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[Stephen Marquard]

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