Hi, this is probably due to the fact the your database journal is getting quite large. Do you cleanup the journal regularly?
On the jackrabbit wiki there is some documentation about it. http://wiki.apache.org/jackrabbit/Clustering?highlight=%28journal%29%7C%28janitor%29#Removing_Old_Revisions You might also take a look at this thread. It's about the same thing. http://hippo.2275632.n2.nabble.com/Lazy-loading-during-startup-td6788047.html#a6788276 Cheers, Jeroen On Thu, Oct 27, 2011 at 9:38 PM, Rama Kesara <[email protected]> wrote: > 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. > > > > 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. > > > > I am using following combinations: > > > > <Repository> > > <FileSystem > class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem"> > > <param name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=dHippoCMS" /> > > <param name="user" value="user1" /> > > <param name="password" value="pass1" /> > > <param name="schemaObjectPrefix" > value="repository_" /> > > <param name="schema" value="mssql" /> > > </FileSystem> > > <Security appName="Jackrabbit"> > > <SecurityManager > class="org.hippoecm.repository.security.SecurityManager" /> > > <AccessManager > class="org.hippoecm.repository.security.HippoAccessManager" /> > > <LoginModule > class="org.hippoecm.repository.security.HippoLoginModule" /> > > </Security> > > <Workspaces rootPath="${rep.home}/workspaces" > defaultWorkspace="default" /> > > <Workspace name="${wsp.name}"> > > <FileSystem > class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem"> > > <param name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=dHippoCMS" /> > > <param name="user" > value="user1" /> > > <param name="password" > value="pass1" /> > > <param > name="schemaObjectPrefix" value="${wsp.name}_" /> > > <param name="schema" > value="mssql" /> > > </FileSystem> > > <PersistenceManager > class="org.apache.jackrabbit.core.persistence.pool.MSSqlPersistenceManag > er"> > > <param name="driver" > value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> > > <param name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=dHippoCMS" /> > > <param name="user" > value="user1" /> > > <param name="password" > value="pass1" /> > > <param > name="schemaObjectPrefix" value="${wsp.name}_" /> > > <param > name="externalBLOBs" value="true" /> > > <param > name="consistencyCheck" value="true" /> > > <param > name="consistencyFix" value="true" /> > > </PersistenceManager> > > ... > > </Workspace> > > ... SAME CONFIG FOR VERSION.. > > <DataStore > class="org.apache.jackrabbit.core.data.db.DbDataStore"> > > <param name="driver" > value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> > > <param name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=dHippoCMS" /> > > <param name="user" value="user1" /> > > <param name="password" value="pass1" /> > > <param name="databaseType" > value="sqlserver" /> > > <param name="minRecordLength" > value="1024" /> > > <param name="maxConnections" value="5" > /> > > <param name="copyWhenReading" > value="true" /> > > <param name="tablePrefix" value="" /> > > <param name="schemaObjectPrefix" > value="" /> > > </DataStore> > > > > <Cluster id="node1" syncDelay="2000"> > > <Journal > class="org.apache.jackrabbit.core.journal.MSSqlDatabaseJournal"> > > <param name="revision" > value="${rep.home}/revision.log" /> > > <param name="driver" > value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> > > <param name="url" > value="jdbc:sqlserver://localhost:1433;databaseName=dHippoCMS " /> > > <param name="user" value="user1" /> > > <param name="password" value="pass1" /> > > </Journal> > > </Cluster> > > </Repository> > > > > Thanks for any help in advance. > > > > Thanks, > > Rama Kesara > > Software Engineer > > Art.com > > Phone: (510) 879-4831 > > > > -- Amsterdam - Oosteinde 11, 1017 WT Amsterdam Boston - 1 Broadway, Cambridge, MA 02142 US +1 877 414 4776 (toll free) Europe +31(0)20 522 4466 www.onehippo.com
