Re: [Hsqldb-user] Big data files ...

[fredt <fr...@us...>]

Because when the rows are deleted or updated, only some of the free space is 
reused.

This has improved a lot in 1.8.0, and more free spaces are used as a result.

If you are using HSQLDB in a commercial app, then you might want to try 
HyperXtremeSQL (http://www.hxsql.com), which is much faster (and this is 
more significant in a PDA) and will have better space reuse than HSQLDB in 
the forthcoming version that is based on HSQLDB 1.8.0 codebase.

Fred Toussi

----- Original Message ----- 
From: "Hillger, Thomas (regio iT)" <Tho...@re...>
To: <hsq...@li...>
Sent: 31 January 2005 07:24
Subject: AW: [Hsqldb-user] Big data files ...


Thanks a lot. Works very fine. But can anyone tell me why the .data files 
get this uge (by running the .script file) and can be shrinked that much?

-----Ursprüngliche Nachricht-----
Von: Felipe Palma Dias [mailto:pal...@ya...]
Gesendet: Donnerstag, 27. Januar 2005 23:04
An: hsq...@li...
Betreff: Re: [Hsqldb-user] Big data files ...


try "CHECKPOINT DEFRAG"

 --- "Hillger, Thomas (regio iT)" <Tho...@re...> 
escreveu:
> Hello list.
>
> Can anyone tel me if it is posible to shrink a .data
> file? I use the DB
> inside a PDA and it gets up to 64MB. I have six
> cached tables. Two of
> them have about 20.000 entries inside.
>
> Any idea?
>
> Regards
>
> Thomas
>
>
>
-------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW --
> Interactive Reporting
> Tool for open source databases. Create drag-&-drop
> reports. Save time
> by over 75%! Publish reports on the web. Export to
> DOC, XLS, RTF, etc.
> Download a FREE copy at
> http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
>
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

=====
------------------------------------------------------- 
Felipe F. Palma Dias
http://geocities.yahoo.com.br/palmadias/

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/


-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool 
for open source databases. Create drag-&-drop reports. Save time by over 
75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a 
FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Hsqldb-user mailing list
Hsq...@li... 
https://lists.sourceforge.net/lists/listinfo/hsqldb-user


-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user