db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan R." <elstefan...@gmail.com>
Subject Compress large table
Date Tue, 13 Mar 2012 16:59:11 GMT

In one of our current projects we are using derby and have some large db
tables (over 20 Million rows and some indexes). 

We decided to clean this table with a scheduled task. Now to be able to free
some disk space we want to compress the files using SYSCS_COMPRESS_TABLE.
What would be the best option to use this function and keep the table lock
as short as possible? Our app needs to keep running while the compression is
taking place.

Do you have any suggestions?


Thank you,



View raw message