Tips on choosing the correct content repository/storage engine

[Emanuele Iannone]

Hi, I'm planning to set up a CMS for my company intranet using Symfony CMF.

I would like to ask some advice on choosing the most appropriate storage engine to use, considering the following:

* ~150 total users, ~50 concurrent

* ~500 files in pdf format, ranging from few kb to 5Mb

* ~1000 web pages, mostly formatted text, with few images

* Categorized and tagged pages and files

* Searching and versioning for both files and pages

* PHP 5.5 on IIS 7.5 on Windows Server 2008

* Access to web server only from local LAN / VPN

* Users are authenticated thorugh IIS by windows authentication

* Web server, database server and storage engine all on the same machine

From what I understood, I think that would be better to use a storage engine like Jackrabbit than a relational database, so my questions are:

1) Setting up a Jackrabbit or tomcat server on the same machine where the web server is running would affect performance more than using simply a RDBMS for storing documents?

2) With the given requirements, for running Jackrabbit it's better to use the simple standalone server or installing tomcat and deploying to it?

Thank you

Emanuele

[Lukas Kahwe Smith]

Yes, I would recommend using Jackrabbit for performance, but also because of features like search and versioning.
Generally standalone is not recommended by the core devs but it works fine for all we can see.
Using a servlet container is usually something that sysadmins prefer.

As for separating the RDBMS. It really depends a lot on how good the network connection is. In general Jackrabbit keeps an in memory cache of nodes. However for your binaries you can configure limits and here it will depend on how you set them and how often those binaries are requested.

regards,
Lukas Kahwe Smith
sm...@pooteeweet.org

[Emanuele Iannone]

Thank you Lukas,

Then I'll go with Jackrabbit, using the standalone server.