[prev in list] [next in list] [prev in thread] [next in thread]
List: hsqldb-user
Subject: Re: [Hsqldb-user] compress large database
From: "Bayless Kirtley" <bkirt () cox ! net>
Date: 2015-10-24 13:32:55
Message-ID: 6973A072109A4149B8F209E764215013 () Tiger
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Excellent idea Fred. Soon as it is proven, I'll be happy to offer it open source.
Bayless
From: Fred Toussi
Sent: Friday, October 23, 2015 10:22 AM
To: HSQLDB user list
Subject: Re: [Hsqldb-user] compress large database
Your charity software would be useful around the world for food banks (as they are \
called over here). Good idea to make it available as open source.
Fred
On Fri, Oct 23, 2015, at 14:18, Bayless Kirtley wrote:
Thanks a lot Fred. Dang, now I remember Shutdown Compact. I guess it's been a long \
time since I had to deal with a larger database.
BTW, it's been a long time since I thanked you for this outstanding piece of \
software. Being retired, I don't develop anything but what I want to and it seems \
everything involves Java and HSQLDB. The only reason I took this one on is it is a \
charity project for a local food pantry, managed by a friend and feeding the needy. \
The reason you don ‘t hear much from me anymore is that there are just never any \
problems.
Bayless
From: Fred Toussi
Sent: Friday, October 23, 2015 6:02 AM
To: HSQLDB user list
Subject: Re: [Hsqldb-user] compress large database
You can use either SHUTDOWN COMPACT or CHECKPOINT DEFRAG to compact the database \
file after removing several large tables.
Alternatively you could use TEXT tables for the raw import of the data. As the data \
for these tables is stored separately in individual files, you can later drop the \
tables and delete their files.
Fred
On Thu, Oct 22, 2015, at 20:34, Bayless Kirtley wrote:
Is there a way to compress a large database after removing several tables? I am \
converting an Access database to HSQL and Java and have several large tables for raw \
import of the Access tables. After massaging them into final form, I drop the raw \
tables but the size of the database files does not seem to notice that. It stays \
about double the size it needs to be.
Thanks
Bayless
------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.6173 / Virus Database: 4450/10871 - Release Date: 10/22/15
------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--------------------------------------------------------------------------------
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.6173 / Virus Database: 4450/10879 - Release Date: 10/24/15
[Attachment #5 (text/html)]
<HTML><HEAD><TITLE></TITLE>
<STYLE type=text/css><!-- \
body{padding:1ex;margin:0;font-family:sans-serif;font-size:small}a[href]{color:-moz-hy \
perlinktext!important;text-decoration:-moz-anchor-decoration}blockquote{margin:0;border-left:2px \
solid #144fae;padding-left:1em}blockquote blockquote{border-color:#006312}blockquote \
blockquote blockquote{border-color:#540000} --></STYLE> </HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Excellent idea Fred. Soon as it is proven, I'll be happy to offer it open
source.</DIV>
<DIV> </DIV>
<DIV>Bayless</DIV>
<DIV> </DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: \
normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'> <DIV style="FONT: 10pt \
tahoma"> <DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=fredt@users.sourceforge.net
href="mailto:fredt@users.sourceforge.net">Fred Toussi</A> </DIV>
<DIV><B>Sent:</B> Friday, October 23, 2015 10:22 AM</DIV>
<DIV><B>To:</B> <A title=hsqldb-user@lists.sourceforge.net
href="mailto:hsqldb-user@lists.sourceforge.net">HSQLDB user list</A> </DIV>
<DIV><B>Subject:</B> Re: [Hsqldb-user] compress large database</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: \
normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'> <DIV style="FONT-SIZE: \
medium; FONT-FAMILY: arial" dir=ltr> <DIV class=defangedMessage>
<DIV id=me03443>
<DIV>Your charity software would be useful around the world for food banks (as
they are called over here). Good idea to make it available as open source.</DIV>
<DIV> </DIV>
<DIV>Fred</DIV>
<DIV> </DIV>
<DIV>On Fri, Oct 23, 2015, at 14:18, Bayless Kirtley wrote:</DIV>
<BLOCKQUOTE class=me03443QuoteMessage type="cite">
<STYLE type=text/css><!-- --></STYLE>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Thanks a lot Fred. Dang, now I remember Shutdown Compact. I guess it's
been a long time since I had to deal with a larger database.</DIV>
<DIV> </DIV>
<DIV>BTW, it's been a long time since I thanked you for this outstanding piece
of software. Being retired, I don't develop anything but what I want to and it
seems everything involves Java and HSQLDB. The only reason I took this one on
is it is a charity project for a local food pantry, managed by a friend and
feeding the needy. The reason you don ‘t hear much from me anymore is that
there are just never any problems.</DIV>
<DIV> </DIV>
<DIV>Bayless</DIV>
<DIV> </DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; \
FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'> <DIV \
style="FONT: 10pt tahoma"> <DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><SPAN style="FONT-WEIGHT: bold">From:</SPAN> <A
title=fredt@users.sourceforge.net href="mailto:fredt@users.sourceforge.net"
defang_rel="noreferrer">Fred Toussi</A></DIV>
<DIV><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN> Friday, October 23, 2015
6:02 AM</DIV>
<DIV><SPAN style="FONT-WEIGHT: bold">To:</SPAN> <A
title=hsqldb-user@lists.sourceforge.net
href="mailto:hsqldb-user@lists.sourceforge.net" defang_rel="noreferrer">HSQLDB
user list</A></DIV>
<DIV><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN> Re: [Hsqldb-user]
compress large database</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; \
FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'> <DIV \
style="FONT-SIZE: medium; FONT-FAMILY: arial" dir=ltr> <DIV \
class=me03443defangedMessage> <DIV id=me03443me54065>
<DIV>You can use either SHUTDOWN COMPACT or CHECKPOINT DEFRAG to compact the
database file after removing several large tables.</DIV>
<DIV> </DIV>
<DIV>Alternatively you could use TEXT tables for the raw import of the data.
As the data for these tables is stored separately in individual files, you can
later drop the tables and delete their files.</DIV>
<DIV> </DIV>
<DIV>Fred</DIV>
<DIV> </DIV>
<DIV>On Thu, Oct 22, 2015, at 20:34, Bayless Kirtley wrote:</DIV>
<BLOCKQUOTE class=me03443me54065QuoteMessage type="cite">
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Is there a way to compress a large database after removing several
tables? I am converting an Access database to HSQL and Java and have several
large tables for raw import of the Access tables. After massaging them into
final form, I drop the raw tables but the size of the database files does
not seem to notice that. It stays about double the size it needs to
be.</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV>Bayless</DIV>
<DIV> </DIV></DIV></DIV>
<DIV>------------------------------------------------------------------------------</DIV>
<DIV><U>_______________________________________________</U></DIV>
<DIV>Hsqldb-user mailing list</DIV>
<DIV><A href="mailto:Hsqldb-user@lists.sourceforge.net"
defang_rel="noreferrer">Hsqldb-user@lists.sourceforge.net</A></DIV>
<DIV><A href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user"
defang_rel="noreferrer">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</A></DIV></BLOCKQUOTE></DIV></DIV></DIV>
<P> </P>
<HR>
------------------------------------------------------------------------------
<P> </P>
<HR>
_______________________________________________<BR>Hsqldb-user mailing
list<BR>Hsqldb-user@lists.sourceforge.net<BR>https://lists.sourceforge.net/lists/listinfo/hsqldb-user \
<P> </P>
<HR>
<P align=left color="#000000">No virus found in this message.<BR>Checked by
AVG - <A href="http://www.avg.com"
defang_rel="noreferrer">www.avg.com</A><BR>Version: 2015.0.6173 / Virus
Database: 4450/10871 - Release Date: 10/22/15</P>
<P> </P>
<P> </P>
<P> </P></DIV></DIV></DIV>
<DIV>------------------------------------------------------------------------------</DIV>
<DIV><U>_______________________________________________</U></DIV>
<DIV>Hsqldb-user mailing list</DIV>
<DIV><A href="mailto:Hsqldb-user@lists.sourceforge.net"
defang_rel="noreferrer">Hsqldb-user@lists.sourceforge.net</A></DIV>
<DIV><A href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user"
defang_rel="noreferrer">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</A></DIV></BLOCKQUOTE></DIV></DIV></DIV>
<P>
<HR>
------------------------------------------------------------------------------<BR>
<P>
<HR>
_______________________________________________<BR>Hsqldb-user mailing
list<BR>Hsqldb-user@lists.sourceforge.net<BR>https://lists.sourceforge.net/lists/listinfo/hsqldb-user<BR>
<P>
<HR>
<A></A>
<P align=left color="#000000" avgcert??>No virus found in this
message.<BR>Checked by AVG - <A
href="http://www.avg.com">www.avg.com</A><BR>Version: 2015.0.6173 / Virus
Database: 4450/10879 - Release Date:
10/24/15</P></DIV></DIV></DIV></BODY></HTML>
------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic