[Cosmo-dev] Results of Hibernate Propfind initial testing

[rletness at simdeskcorp.com]

Bobby Rullo wrote:

>
>
> Cosmo JCR, build: 2206
> ----------------------------------
> Avg Time: 742 seconds (two runs)
>
> Cosmo Hibernate, build: 922
> ---------------------------------------
> Avg Time: 708 seconds (three runs)
>
>
Some more initial data:

I just did a WebDAV "ls" using the cadaver client on a collection with
4000 items.   This essesntially is a propfind because it retrieves all the
attributes.  Before Brian's changes on Friday it was taking a good
20-30 seconds, and now it takes under 10.  I confirmed that there
are two queries issued.  One to get all the children in the collection
and one to load all the attributes for all the children.
 
This is running against a MySQL5 db running on another box. 
So the good news is that being able to offload the query work onto
a separate box will improve performance significantly.  I should also
mention that you can't really do this with Cosmo JCR.  I had Cosmo
JCR running against a  MySQL5 db and the number weren't that
different from the Derby numbers.  The reason is that the querying and
indexing is still done in the jvm using Lucene.

-Randy