Dear All,
I have the following questions to Apache Derby Database:
1. Does Derby have any limit on the database size? ( the size of our
Database is about 3,1 GB )
2. Dose Derby have any problems to manage database sizes over 1GB?
3. We have with Derby database many performance problems, we got some
times an Out of Memory Error because of Java heap space, and our Server was
down, the error was like follows:
2012-02-23 12:41:58,353 ERROR - Error in ID LOGIK call:
2012-02-23 12:41:58,353 ERROR - Service: scores.GetAllCasesFiltered
2012-02-23 12:41:58,353 ERROR - Parameter: {IP=192.168.144.72,
MODULE_ACTIVE=true, CASE_ID=*,
SESSION_ID=zisruwoldl_C0A89048_1329995925686, DEPARTMENT=*, MODUL=9,
PROXY_MODULES=ID_SCORER_PKMS, LASTNAME=*, FIRSTNAME=*, WARD=*}
2012-02-23 12:41:58,353 ERROR - Throwable: Java heap space
java.lang.OutOfMemoryError: Java heap space
Is it because of the size of our database (3,1 GB!)? and what can I do to
improve the performance of the Derby Database, and to resolve the error?
Thanks,
and best regards
Mit freundlichen Grüßen
i.A.
Luay Awad
Informationstechnologie
Märkische Gesundheitsholding
GmbH & Co. KG
Paulmannshöher Str. 14
D-58515 Lüdenscheid
Fon +49 (0) 2351- 462148
Märkische Gesundheitsholding GmbH & Co. KG
Sitz und Gerichtsstand: Lüdenscheid
Aufsichtsratsvorsitzender: Detlef Seidel
Geschäftsführer: Robert Schüwer, PD Dr. Bernhard Schwilk, Dr. Günter Peters,
Matthias Germer, Johannes Josef Wittenbrink
Persönlich haftender Gesellschafter: Märkische Gesundheitsholding Verwaltungs
GmbH
Amtsgericht Iserlohn HRA 4297