[Cosmo-dev] Results of Hibernate Propfind initial testing

[rletness at simdeskcorp.com]

Brian Moseley wrote:

>
> excellent. how did you configure hibernate to load all the attributes
> for all the children?
>
In Hibernate you can specify one of any number of "fetching" strategies
for collections.  One strategy is "subselect", which means that Hibernate
will fetch the collections for all objects loaded in the previous query
using a subselect.  Another strategy is "join" which means the collection
will be fetch using a join.  The drawback of this is that you essentially
have no lazy loading.  The "subselect" strategy is a good inbetween.

> also, is a second ls perceptibly faster? i'd hope so, since all of the
> items are now loaded into the hibernate l2 cache.
>
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.

> i'd also be curious to see dao layer timing comparisons between jcr
> and hibernate, which would remove all of the dav layer object
> instantiations.

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.

-Randy