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
