Hi Deepak,
Derby is a terrible (but free) option for live systems.
I've tried a bit of everything and here's pretty much my comments.
from best backend to worst.
- bdb: is the best option if you don't have to redistribute your
application (server only).
- h2: embedded databaser "a la derby" but with no file problems and
way less memory usage: http://www.h2database.com/html/frame.html
- postgresql: inconvenience of a remote database, but pretty fast,
stable, and not using much memory
- mysql: problems to setup (see other people on the list), but
working. Overall I found it was less responsive than postgresql
- derby: excellent license, free, and already included, but terrible
on performance, memory usage, and other corruptions.
- cqfs: from what I remember was a really good Return on Investment,
but haven't used in a year now. Ask the magnolia team for answers.
Note, this is only MY experience of the backends, and the results of
MY tests here with Magnolia. I may surely be wrong, and it may surely
also depends on which webserver you are using.
Anyways, I just hope it helps you.
Regards,
Nicolas,
On Sep 4, 2006, at 2:03 PM, Deepak Mittal wrote:
Thanks for the response John.
My application is running on Linux. I have increased the open file
limit
to more than 75,000; but that only means that the tomcat server will
take some more time to crash; once the limit is exhausted.
The root cause of the problem is that there is some component
(probably
derby) in my magnolia application which is not releasing the
file-handles.
I am already considering migrating my application to a different
database such as mysql or postgres.
Best Regards,
~Deepak
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 04, 2006 6:10 AM
To: [email protected]
Subject: Re: [magnolia-user] Tomcat server crash because of "too many
files open" | Magnolia 3.0 rc2
On 9/1/06, Deepak Mittal <[email protected]> wrote:
Hello Magnolians,
I am using Magnolia 3.0 rc2 to host my web-application on tomcat 5.5
using derby database (default).
However, my tomcat server keeps crashing after few days because of
"too
many files open" exception.
Is there anyone else who is facing a similar problem; and any
tips/work-around for this problem?
Hi Deepak,
are you running on a linux/unix system ?
Have you investigated "man ulimit" ?
Have you googled for that problem in the large ? google : 'tomcat "too
many files open"' ?
Best regards,
--
John Mettraux -///- http://jmettraux.openwfe.org
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
