jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: Does jackrabbit suffer from n+1 SQL SELECT queries?
Date Tue, 14 Aug 2007 07:44:05 GMT
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.


View raw message