You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by Andrey Adamovich <an...@yahoo.com> on 2009/10/26 11:05:00 UTC

Node.remove performance for combination of bundled OraclePersistenceManager

Hi guys!

Does any of you have any experience with using OraclePersistneceManager and its performance on extremely large node set?

We have 2 setups to compare: 1st is our local test environment with about 300,000 bundles stored in DEFAULT_BUNDLE table (we use only one workspace called "default"), and 2nd is pre-production system (which I don't have access to, but I can analyse the logs) with 50,000,000 records in the same table. 

The problem is that node removal (removed node usualy contains from 50 to 100 subnodes) takes from 6 to 10 seconds on 2nd system and is always below 300 miliseconds on 1st system which by the way is a virtual environment. 

 
Can anyone give any advice on what could be done about that?

Best regards,
Andrey Adamovich