db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: About db file sizing
Date Thu, 09 Feb 2012 13:46:50 GMT
Hi Carlos,

Some responses inline...

On 2/8/12 3:00 PM, Carlos de Luna Saenz wrote:
> I really don't know if this is a good couple questions or not...
> We are developing an embedded DB app that has a 1.74GB of files for the
> database
> I wonder if there is something like a shrink or compact command that
> will reduce the amount of space for the app DB.
The SYSCS_UTIL.SYSCS_COMPRESS_TABLE and 
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE procedures can be used to 
reclaim unused space. Don't know how effective they will be for your 
needs though. See 
http://db.apache.org/derby/docs/10.8/ref/ref-single.html#rrefaltertablecompress
> Is there a way to make it user/password protected? We don't want to
> "start" a server on the program side but password protection would be
> appreciated.
Derby currently supports 3 user/password authentication schemes, 
discussed here: 
http://db.apache.org/derby/docs/10.8/devguide/devguide-single.html#cdevcsecure42374 
. In the next major feature release (10.9), we hope to introduce another 
authentication scheme which should be easier to configure and 
administer; it is described by the functional spec attached to 
https://issues.apache.org/jira/browse/DERBY-866

Hope this helps,
-Rick
> Greetings
>


Mime
View raw message