|Subject||Re: [firebird-support] Database Too Large.|
I have an Event.log (Contain everything that happens in the radio) and a History (all the songs played) but if i check the Backup Size is 6/7 mb.
The SAMBC.FDB it is growing every day, before reset was 3 Mb (with ALL of the webradio songs perfetly loaded into db) and now after 4 days is 8 Mb!!!!!
If you need to restart SAM Broadcaster you force the program to read 200 MB of database (it freeze!!!) when 6 Mb is enough (loading REALLY FAST), could you tell me why ??
What's' inside the database ? There is a way to decrease the size deleting gargage (SAM's forum admin said garbage probably is the problem)..
I can't understand why after the first run the db is 6 Mb (Correct) and WITHOUT add new records to the db (no songs added during last few days) the size increase.
What do you think about it ?? I'm just thinking to migrate mySQL db architecture.
Please help me !!! There is a tool to decrease the db??
Il 27/06/2014 10:36, Lester Caine email@example.com [firebird-support] ha scritto:
On 27/06/14 08:43, 'Stefano.firstname.lastname@example.org' email@example.com
> 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