You've gotten all the answers on how, now, let me ask why you want it
compressed.
What difference does it make if it stays 4 MB (which is a really small
database for us) ??
It's less work to simply re-use the now used pages, when adding data, than
it is for the engine to go out and get more disk space from the OS, like it
has too when it's "compressed"..

Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: Louis Louw [mailto:louis@...]
Sent: Wednesday, July 23, 2003 12:42 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Database compress/purge


Hi!

I deleted all rows fromall my tables, but the database is still 4MB big.
(It started out at only 200k)
What command or tool do I need to use to "compress" the table, clearing all
empty pages?

thanx
Louis



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3512152.4794593.1261774/D=egroupweb/S=17051153
86:HM/A=1595056/R=0/SIG=124bf4lrb/*http://ashnin.com/clk/muryutaitakenattogy
o?YH=3512152&yhad=1595056> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3512152.4794593.1261774/D=egroupmai
l/S=:HM/A=1595056/rand=185691871>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]