Would it be viable to add an option to retrieve everything in a given NodeIterator as a single DB query when a DB persistence manager is used? It seems to me that such an option would help out a lot for cases like retrieving search results, getting all children of a node, etc.
-Brian On 8/14/07, Marcel Reutegger <[EMAIL PROTECTED]> wrote: > > Phillip Rhodes wrote: > > Does jackrabbit issue a select statement in order to retrieve all the > > properties and their values for a node? If so, wouldn't jackrabbit have > the > > problem of issuing 400 different select statements as it iterates over > 400 > > nodes? > > if none of the nodes are present in the cache, then jackrabbit will > execute > individual select statements to retrieve nodes. using the > SimpleDbPersistenceManager it will even execute 400 + (400 * > numberOfPropertiesPerNode). The BundleDbPersistenceManager circumvents > this by > loading all properties in a single SQL statement. > > regards > marcel >
