It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×4,712
×4,320

question asked: Oct 12 '12, 5:07 a.m.
question was seen: 5,031 times
last updated: Oct 12 '12, 8:45 a.m.

Related questions

Use Derby or DB2 for best performance?

0
Sandra Bernspang (15●2●5●8) | asked Oct 12 '12, 5:07 a.m.
JAZZ DEVELOPER
Does anyone have any experience around performance for Derby vs DB2? I have a demo environment with the Money that Matters sample on a VMWare image where I currently use Derby. I wonder if there is any performance wins to be done by changing to DB2?

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Ralph Schoon (63.6k●3●36●46) | answered Oct 12 '12, 7:00 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Sandra,

there is a clear statement in the download pages not to use derby for anything serious. You can and should only use it for demos and for development testing or even for simple test servers. Don't use it for real work, especially since DB2 is a free download.
I have been told derby does not scale. I have no numbers, but I was told not to try to use it for production even with less than 10 users.

DB2 might require more resources e.g. a separate machine as DB server, but should be faster and more reliable provided it has the resources it needs and the connection between DB server and App server is not a bottle neck.
Comments
Sandra Bernspang commented Oct 12 '12, 8:34 a.m.
JAZZ DEVELOPER

Thanks Ralph. The VMWare image is only to be used for demo purposes, with 1 user logged in simultaneously and only the 10 or so MTM sample users created. Based on your reply, I think it would not be worthwhile to change to DB2, if DB2 requires more resources of the VMWare.

Ralph Schoon commented Oct 12 '12, 8:44 a.m. | edited Oct 12 '12, 8:45 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Sandra, actually in that case I would not switch to DB2 (if you don't need RRDI).

In fact I have a small tool that I and a couple of other IBM users use to maintain backups of demo environments. It is called CLM Confiuration Manager and available on IRAM. I can not yet publish it externally, and it can only be used by IBM users so far, but it is most useful and allows to manage several versions of Derby/Tomcat based demo environments. Backup, deployment etc. is fully automated. I don't use VMWares, a backup is around 400 MB instead of GB's. The tool also allows sharing of the demo configurations and easy adjustment if you move to a different machine.

So for this usage, I always use Derby.

PS: If you see performance issue in VMWare with 4.0 you might see https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=216290 the work item contains a work around.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.