Anyone ever tried to use Derby or HSQLDB in a production environment? Any good, bad or ugly experiences?
+4
A:
There is a comparison of embedded databases on the H2 website (H2 is another embedded Java DB that is very fast, BTW):
This should give you some facts.
Alexander Klimetschek
2009-07-28 11:21:16
+2
A:
I've been using Derby 24x7 in production for over 4 years. It's a great database!
Bryan Pendleton
2009-12-07 16:45:44
What sort of traffic do you get? I'm interested in running Derby in production as well and would like to know if you could spare any tips.
Luke
2009-12-20 10:42:01
It's not an enormously high-volume application. It's an internal build-and-test management system which monitors and schedules activity in an automated server farm. It probably processes about 5 transactions a second, around the clock, on average.The two most important tips, in my opinion, are: (1) pay attention to your physical schema (and check query plans to see that the schema is indeed working), and (2) give Derby enough memory so that it can cache database pages successfully (again you can see information about this in the query plan output)
Bryan Pendleton
2009-12-23 15:44:58