Cloudscape Database Size limitation

Thread view:

aixunix@gmail.com - 23 Nov 2005 01:51 GMT

Does anyone know cloudscape database size limitation? Any documentation
states the relation between cloudscape database size and performance?

Reply to this Message

Dyreatnews@sun.com - 23 Nov 2005 09:15 GMT

> Does anyone know cloudscape database size limitation? Any documentation
> states the relation between cloudscape database size and performance?

For Derby (open source Cloudscape) I don't think there is a limitation
(other than those imposed by OS, jvm, available memory and disk). I
have seen it run with 10 GB, and I believe IBM is planning on testing
with up to 100 GB.

To get performance with a large database you may need to adjust the
pageCacheSize (the default is only 4MB).

The tests I have seen indicate that Derby performs better (relative to
other dbs) the larger the database is.

(I have cc'ed my reply to the derby-user mailing list, where more
derby experts are likely to see it. You can subscribe to and browse
this (and other) mailinglist at

http://db.apache.org/derby/

Signature

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...