Hi,
I use firebird 2.5 classic server on windows operating system.
Because our database file is quite big (18GB) and it starts to cause 
(because of its size) some maintenance inconvenience we decided to try 
to shrink it. After checking database statistics we deleted "useless" 
records in tables that took the most space, we updated old useless blob 
fields with null values. After backup and restore it turned out that new 
database is only 3GB smaller than original. We checked the statistics  
and according to results we have 2,3GB raw data in database file. 
Restore only metadata creates database of 70MB size, restoring without  
active indexes results with file 500MB smaller than original. I'm very 
curious - so what makes our database file so big? Sum of clear metadata 
and raw data is about 2,4GB, and what with other 12GB?  Is anything we 
can do to shrink our big database file (drop useless indexes or 
something like that)?


Thank you in advance for your answer.


Best regards,
Małgorzata Barchańska


-- 
Pozdrawiam
Małgorzata Barchańska


Fast Data Sp. z o.o.
Aleja Zwycięstwa 96/98, 81-451 Gdynia
Tel.: (58) 732 72 01
http://www.fastdata.com.pl/
NIP : 5862214954,REGON : 220595046
KRS : 0000304310, Kapitał zakładowy 50 000 zł




------------------------------------
Posted by: =?UTF-8?Q?Ma=c5=82gorzata_Barcha=c5=84ska?= <gosia@...>
------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com 
    firebird-support-fullfeatured@yahoogroups.com

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

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/