Re: odb file sizes

Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]> 
Hi Manolis,

> It seems that ODB file sizes grow with time but when I create another 
> odb file and copy all the tables from the old one to the new, the new 
> file size is back to normal (I mean small).

Try entering "SHUTDOWN COMPACT" in the "Tools|SQL" dialog. Afterwards,
close and re-open the database.

> Maybe OOo 2.0 needs a "pack database" menu entry.

Ehm - yes, but this won't get in for 2.0 anymore.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.