Issue 105237 - [HSQLdb] GUI shuold offer the ability to compact data files
Summary: [HSQLdb] GUI shuold offer the ability to compact data files
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
Keywords: usability
Depends on:
Reported: 2009-09-21 10:45 UTC by schaber
Modified: 2009-11-24 16:30 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description schaber 2009-09-21 10:45:16 UTC
When creating a CSV file as text table, and inserting and updating rows, then a
lot of empty lines are generated in the CSV file. The blank lines are spreaded
over the whole file. The number of blank lines grows with each row update, and
you end up with a file that has so many blank lines that you hardly find the non
empty lines when opening the file in an editor.
Comment 1 schaber 2009-09-22 22:25:10 UTC
I would also be happy about a workaround (except manually removing the blank lines)
Comment 2 drewjensen.inbox 2009-09-29 05:50:21 UTC
@schaber - Well it isn't actually a work around, it is as designed by the HSQLdb
project team.

With the Base file opened and connected. (meaning you need to enter the table
section or be displaying data in a form)

Open menu item: Tools>SQL

Enter, and execute, the command: SHUTDOWN COMPACT

You will need to close the Base file at this point - the blank lines are removed
from any attached text files.

So I could say this is as designed or WORKSFORME and call this more a support
query - but instead

@schaber - I hope you don't mind if I use your entry of this issue as a specific
use case for a more generalized issue.

"Update in text table creates blank lines" is just one instance of when users
need a compact command, to reclaim space in cached tables is another.

Currently the user must use either the CHECKPOINT DEFRAG or SHUTDOWN COMPACT
command in the SQL window. The latter command is required to purge blank lines
from attached text table files and then requires the user to close the Base file.

My suggestion would be to add a new item to the task list under Tables with the

A description entry of:
This operation shrinks all files to the minimum size.

Clicking on the task item would:
close any open component windows (forms, dataviews, etc) 
execute the SHUTDOWN COMPACT command for the active connection
reconnect the active connection

Comment 3 schaber 2009-09-29 10:04:12 UTC
Good enough for me. I can incorporate this into my basic macros. Thanks a lot.
Comment 4 Mechtilde 2009-11-24 16:30:13 UTC
worksforme -> closed