db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Derby memory consumption with many databases
Date Thu, 07 Jan 2010 16:25:15 GMT
√ėyvind Harboe <oyvind.harboe@zylin.com> writes:

> Did I understand correctly that  derby.storage.pageCacheSize is configured
> per database?
> Is there a way to set the page cache size for derby across all databases in
> the JVM when running Derby in embedded mode?
> Background:
> We are running Derby in an application where there is one database per client.
> Eventually we would want to update the database model to allow all clients
> to be inside a single database, but that is a big undertaking.

In case you go that route, I just thought I'd mention here that Derby
supports standard SQL schemas and SQL authorization (so users would be
protected from accessing each others schemas) in contrast to
e.g. MySQL, for which database and schema is more or less the same


View raw message