Stats: Node Creation Time is 20-40 seconds

[sstrickland <ss...@costco.com>]

The session.save() and node.checkin() statement are causing the delay.  

I started with a new repository on my PC and deleted/recreated the tables on
the iSeries.  

I am loading a simple hierarchy:
   Forms Node                                     (1x total to parent root)   
      PEPPA node                                  (1x total to parent Forms) 
         PEPPACAT Node                         (3x total to parent PEPPA) 
            PEPPASUB Node                      (3-5x for each parent
PEPPACAT)
               PEPPAJOB#### Node         (4x for for each parent PEPPASUB)

There are 3-5 user (String) properties for each node (Forms ->
PEPPAJOB####).


I printed a Date/Time for each node as it is created.  This is a partial
listing:
Forms tree removed
Wed Apr 11 16:17:21 PDT 2007 - /Forms
Wed Apr 11 16:17:34 PDT 2007 - /Forms/PEPPA
Wed Apr 11 16:17:51 PDT 2007 - /Forms/PEPPA/PEPPACAT001
Wed Apr 11 16:18:12 PDT 2007 - /Forms/PEPPA/PEPPACAT001/PEPPASUB001
Wed Apr 11 16:18:40 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB001/PEPPAJOB001
Wed Apr 11 16:19:15 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB001/PEPPAJOB002
Wed Apr 11 16:19:57 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB001/PEPPAJOB003
Wed Apr 11 16:20:35 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB001/PEPPAJOB004
Wed Apr 11 16:21:08 PDT 2007 - /Forms/PEPPA/PEPPACAT001/PEPPASUB002
Wed Apr 11 16:21:45 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB002/PEPPAJOB001
Wed Apr 11 16:22:23 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB002/PEPPAJOB002
Wed Apr 11 16:22:52 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB002/PEPPAJOB003
Wed Apr 11 16:23:28 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB002/PEPPAJOB004
Wed Apr 11 16:23:48 PDT 2007 - /Forms/PEPPA/PEPPACAT001/PEPPASUB003
Wed Apr 11 16:24:10 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB003/PEPPAJOB001
Wed Apr 11 16:24:36 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB003/PEPPAJOB002
Wed Apr 11 16:25:03 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB003/PEPPAJOB003
Wed Apr 11 16:25:29 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB003/PEPPAJOB004
Wed Apr 11 16:25:58 PDT 2007 - /Forms/PEPPA/PEPPACAT001/PEPPASUB004
Wed Apr 11 16:26:35 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB004/PEPPAJOB001
Wed Apr 11 16:27:02 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB004/PEPPAJOB002
Wed Apr 11 16:27:31 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB004/PEPPAJOB003
Wed Apr 11 16:27:57 PDT 2007 -
/Forms/PEPPA/PEPPACAT001/PEPPASUB004/PEPPAJOB004
Wed Apr 11 16:28:20 PDT 2007 - /Forms/PEPPA/PEPPACAT002
Wed Apr 11 16:28:48 PDT 2007 - /Forms/PEPPA/PEPPACAT002/PEPPASUB005
Wed Apr 11 16:29:20 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB005/PEPPAJOB001
Wed Apr 11 16:29:48 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB005/PEPPAJOB002
Wed Apr 11 16:30:18 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB005/PEPPAJOB003
Wed Apr 11 16:30:47 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB005/PEPPAJOB004
Wed Apr 11 16:31:10 PDT 2007 - /Forms/PEPPA/PEPPACAT002/PEPPASUB006
Wed Apr 11 16:31:40 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB006/PEPPAJOB001
Wed Apr 11 16:32:06 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB006/PEPPAJOB002
Wed Apr 11 16:32:33 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB006/PEPPAJOB003
Wed Apr 11 16:33:04 PDT 2007 -
/Forms/PEPPA/PEPPACAT002/PEPPASUB006/PEPPAJOB004


Node Creation Time is 20-40 seconds!!!


You mentioned using a bundle persistence manager.  How do I
download/install/configure it?  I am using WebSphere 5.1 (WDSc).  My current
settings/configurations are in a previous thread


Any help would be appreciated!

Thanks,

Skip











Jukka Zitting wrote:
> 
> Hi,
> 
> On 4/11/07, sstrickland <ss...@costco.com> wrote:
>> I use a db2 database on an iSeries (AS400) to store my project.  I
>> connect
>> just fine, and I can create nodes, child nodes and grandchild nodes,
>> along
>> with appropriate properties.  It's just that it is so very slow.  20-30
>> seconds per node!  Am I doing anything wrong?
> 
> You are probably running the content repository on a separate server
> than the database. The database persistence manager performance is
> quite sensitive to network latency, so the roundtrip time to the
> database server should be < 10ms.
> 
> I assume you currently use the default database persistence manager in
> Jackrabbit 1.x. You might want to try the bundle persistence manager
> in the Jackrabbit trunk since it's not as latency-constrained as the
> current database persistence manager.
> 
> BR,
> 
> Jukka Zitting
> 
> 

-- 
View this message in context: http://www.nabble.com/Creating-Nodes-is-Excruciatingly-Slow-tf3556976.html#a9950536
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.