From users-return-18279-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org  Thu Oct 27 19:39:21 2011
Return-Path: <users-return-18279-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 081489FC5
	for <apmail-jackrabbit-users-archive@minotaur.apache.org>; Thu, 27 Oct 2011 19:39:21 +0000 (UTC)
Received: (qmail 35740 invoked by uid 500); 27 Oct 2011 19:39:20 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 35705 invoked by uid 500); 27 Oct 2011 19:39:20 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 35697 invoked by uid 99); 27 Oct 2011 19:39:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 19:39:20 +0000
X-ASF-Spam-Status: No, hits=-0.1 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of RKesara@art.com designates 64.18.0.26 as permitted sender)
Received: from [64.18.0.26] (HELO exprod5og113.obsmtp.com) (64.18.0.26)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 27 Oct 2011 19:39:14 +0000
Received: from 1-v-ap-relay01p.art.com ([74.123.7.250]) by exprod5ob113.postini.com ([64.18.4.12]) with SMTP;
	Thu, 27 Oct 2011 12:38:54 PDT
Received: from 1-v-ap-owa01p.art.com ([10.130.2.239]) by 1-v-ap-relay01p.art.com with Microsoft SMTPSVC(6.0.3790.4675);
	 Thu, 27 Oct 2011 12:38:53 -0700
Received: from RWC-EXCHANGE.art.com ([10.130.66.206]) by 1-v-ap-owa01p.art.com with Microsoft SMTPSVC(6.0.3790.4675);
	 Thu, 27 Oct 2011 12:38:53 -0700
Received: from pwl-exmbx01.art.com ([10.20.110.20]) by RWC-EXCHANGE.art.com with Microsoft SMTPSVC(6.0.3790.3959);
	 Thu, 27 Oct 2011 12:38:53 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CC94E0.0ECDC30E"
Subject: DbFileSystem in repository.xml
Date: Thu, 27 Oct 2011 12:38:51 -0700
Message-ID: <BCD1AD7BDB7A2843BBE2D7036A5BB5D40348EA24@pwl-exmbx01>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: DbFileSystem in repository.xml
Thread-Index: AcyOug26++0CAEFPTmKfcJbnZq4Y3gGJDMig
From: "Rama Kesara" <RKesara@art.com>
To: <users@jackrabbit.apache.org>,
	<hippo-cms7-user@lists.onehippo.com>
X-OriginalArrivalTime: 27 Oct 2011 19:38:53.0362 (UTC) FILETIME=[0F168120:01CC94E0]

------_=_NextPart_001_01CC94E0.0ECDC30E
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am seeing that everytime I restart my server, it is taking close to
3-4 minutes for initiation if I configure my fileSystem as DbFileSystem.

=20

1)       Is there something that can be configured to skip scanning of
existing tables or probably recreation of tables everytime I start the
server?

2)      Is there something that we can configure to speedup this
process? From the configuration below, anyone see outstanding issues
that might create a performance overhead during server startup.

=20

I am using following combinations:

=20

<Repository>

                <FileSystem
class=3D"org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">

                                <param name=3D"url"
value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />

                                <param name=3D"user" value=3D"user1" />

                                <param name=3D"password" value=3D"pass1" =
/>

                                <param name=3D"schemaObjectPrefix"
value=3D"repository_" />

                                <param name=3D"schema" value=3D"mssql" =
/>

                </FileSystem>

                <Security appName=3D"Jackrabbit">

                                <SecurityManager
class=3D"org.hippoecm.repository.security.SecurityManager" />

                                <AccessManager
class=3D"org.hippoecm.repository.security.HippoAccessManager" />

                                <LoginModule
class=3D"org.hippoecm.repository.security.HippoLoginModule" />

                </Security>

                <Workspaces rootPath=3D"${rep.home}/workspaces"
defaultWorkspace=3D"default" />

                <Workspace name=3D"${wsp.name}">

                                <FileSystem
class=3D"org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">

                                                <param name=3D"url"
value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />

                                                <param name=3D"user"
value=3D"user1" />

                                                <param name=3D"password"
value=3D"pass1" />

                                                <param
name=3D"schemaObjectPrefix" value=3D"${wsp.name}_" />

                                                <param name=3D"schema"
value=3D"mssql" />

                                </FileSystem>

                                <PersistenceManager
class=3D"org.apache.jackrabbit.core.persistence.pool.MSSqlPersistenceMana=
g
er">

                                                <param name=3D"driver"
value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />

<param name=3D"url"
value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />

                                                <param name=3D"user"
value=3D"user1" />

                                                <param name=3D"password"
value=3D"pass1" />

                                                <param
name=3D"schemaObjectPrefix" value=3D"${wsp.name}_" />

                                                <param
name=3D"externalBLOBs" value=3D"true" />

                                                <param
name=3D"consistencyCheck" value=3D"true" />

                                                <param
name=3D"consistencyFix" value=3D"true" />

                                </PersistenceManager>

                                ...

                </Workspace>

                ... SAME CONFIG FOR VERSION..

                <DataStore
class=3D"org.apache.jackrabbit.core.data.db.DbDataStore">

                                <param name=3D"driver"
value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />

                                <param name=3D"url"
value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />

                                <param name=3D"user" value=3D"user1" />

                                <param name=3D"password" value=3D"pass1" =
/>

                                <param name=3D"databaseType"
value=3D"sqlserver" />

                                <param name=3D"minRecordLength"
value=3D"1024" />

                                <param name=3D"maxConnections" =
value=3D"5"
/>

                                <param name=3D"copyWhenReading"
value=3D"true" />

                                <param name=3D"tablePrefix" value=3D"" =
/>

                                <param name=3D"schemaObjectPrefix"
value=3D"" />

                </DataStore>

               =20

                <Cluster id=3D"node1" syncDelay=3D"2000">

                  <Journal
class=3D"org.apache.jackrabbit.core.journal.MSSqlDatabaseJournal">

                                <param name=3D"revision"
value=3D"${rep.home}/revision.log" />

                                <param name=3D"driver"
value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />

                                <param name=3D"url"
value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS " />

                                <param name=3D"user" value=3D"user1" />

                                <param name=3D"password" value=3D"pass1" =
/>

                  </Journal>

                </Cluster>         =20

</Repository>

=20

Thanks for any help in advance.

=20

Thanks,

Rama Kesara=20

Software Engineer

Art.com

Phone: (510) 879-4831

=20


------_=_NextPart_001_01CC94E0.0ECDC30E--