[Cosmo-dev] Results of Hibernate Propfind initial testing

[rletness at simdeskcorp.com]

Brian Moseley wrote:

>
> nope. the problem is that several of the properties for non-collection
> resources (content length, type, encoding, language) are stored in
> this separate attributes table. these properties are returned as part
> of an "allprop" propfind response, the most common type of propfind,
> so we load them whenever we materialize an item from the database.


The way it is setup now is that one query is issued to get all the
children.  This loads all the data from the "item" table.  Then the first
call to access an item attribute actually results in all the attributes 
for all
the items loaded in the first query to be loaded.  So it should only
be two queries.  I'll verify it thats what really happens.  Did you
update the DavResourceFactory to not make a call to findItemByPath()
for each child item?   That results in atleast 3 queries for each item.

-Randy