On 27/06/14 08:43, 'stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support] wrote: > i run SAM Brodcaster (Webradio Automation Software) with firebird > database. I've a big problem because SAMDB.FDB increase day after day in > an exaggerated way. > After 150 days of running the db size is 200 Mb !!!!!! Someone in SAM > Broadcaster forum said to me that is a garbage problem.. Well adding 200Mb each day should not cause a problem.
> Because if i need to restart my program it freeze when reading a Db so > large. So i need to ricreate a new one looosing all of my data !!! > The correct dbsize is about 7/10 Mb !!!!! > Could you tell me how can i do to decrease the db size ?? > There is a tool to delete the garbage data..? You do not say what software you are using to access the database. It's this which is leaving older records which are not being allowed to clear. I presume if you do a backup and restore you end up with a 10Mb database? A bigger database size is not a problem if the older records are allowed to be reused, a growing database can be tidied but it's the accessing software that actually needs fixing. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk