[Cosmo-dev] Results of Hibernate Propfind initial testing

[Brian Moseley]

On 9/2/06, rletness at simdeskcorp.com <rletness at simdeskcorp.com> wrote:

> I haven't configured the l2 cache yet, so there is really no l2 caching
> now.  Thats a todo...and there are a lot of things to worry about when
> determining what and what not to cache.

cool. we'll definitely get some improvements there.

> I happen to to have the dao layer timing for hibernate.  It takes around
> the same time (7s) to find the collection by name, get all the children,
> and retrieve the attributes.  This is MySQL again.  So the majority of time
> is spent on the two queries that retrieve thousands of records.

it would be interesting to record how often writes occur to the item
and attribute tables vs reads. it's possible that mysql's query
caching could help, if writes wind up being very infrequent.