Thunderstone Support Forums

We've got a table whose size is close to the 2 GB file limit.

Over time, we've deleted certain records from this table, but the .tbl size hasn't shrunk-- in fact, it's grown a little. Is there a way we can compress the file a bit, without having to drop and recreate the table? Thanks.

You'll have to use copydbf to compact it. Make sure the table is not being modified while it's being copydbf'd. Then you'll have to recreate all of the indices for the compacted table.

You may also wish to move some of the larger fields out to blob datatypes while you're in the process.