[Building Sakai] Excessive querying of SAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[Joshua Swink]

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