Re: [firebird-support] Database Too Large.

[marcus mar...@antiphasis.net [firebird-support]]

IIRC that's the second user having problems with SAM Broadcast using 
firebird. The Product company Spacial Audio has its own support site at
https://spacialaudio.zendesk.com/home, that should be your way to ask 
for help, as they do know how their application talks to the database.

And, as Werner has written, the database size is not the problem. A 
database of 200 MB is a 'snack'...





Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> Hi Stefano,
>
> To decrease database size you need to make backup/restore.
>
> Then, to keep its growth under control, you need to perform the
> following maintenance procedure:
>
> 1) stop Firebird server and then start it immediately (less than 3 sec
> downtime).
> 2) run
> gfix -sweep -user SYSDBA -pass masterkey 
>
> that's all.
>
> Regards,
> Alexey Kovyazin
> IBSurgeon
>
> 

Re: [firebird-support] Database Too Large.

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Stefano,

To decrease database size you need to make backup/restore.

Then, to keep its growth under control, you need to perform the 
following maintenance procedure:

1) stop Firebird server and then start it immediately (less than 3 sec 
downtime).
2) run
gfix -sweep -user SYSDBA -pass masterkey 

that's all.

Regards,
Alexey Kovyazin
IBSurgeon

Re: [firebird-support] Database Too Large.

[Werner werner...@gmx.ch [firebird-support]]

Hi Stefano,

On 6/27/2014 11:01, 'stefano.mala...@gmail.com' 
stefano.mala...@gmail.com [firebird-support] wrote:


I use SAM Broadcaster Webradio Automation Program.
You need to give more information on the above, a link would already be 
good.


Better would be what Firebird SQL access tool is being used, e.g. I use 
Python to develop my app and I can use the access tools kinterbasdb or 
fdb and some others if I would connect via ODBC.


The database size is not the problem, there are systems out there which 
use Firebird SQL with much larger db sizes and no performance problems.


In your case I would guess that the software is not closing transactions 
correctly.  If all is done correctly then the garbage collection will 
happen automagically.


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??
Wrong place to ask that question, we here 'feel' that Firebird SQL is 
the better solution but then your mileage may very.


Werner

Re: [firebird-support] Database Too Large.

['stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support]]

I use SAM Broadcaster Webradio Automation Program.
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??


Regards, Stefano.






Il 27/06/2014 10:36, Lester Caine les...@lsces.co.uk [firebird-support] 
ha scritto:
>
> 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
>
> 




-- 
*MALARADIO
Infos & Contacts*
Stefano Malaisi

www.malaisi.com 
www.malaradio.com 
stefano.mala...@gmail.com 

Mobile: +39-3356365644


 
 

Re: [firebird-support] Database Too Large.

[Lester Caine les...@lsces.co.uk [firebird-support]]

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

[firebird-support] Database Too Large.

['stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support]]

Hi,
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..
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..?


Please help me.


Regards, Stefano.
-- 
*MALARADIO
Infos & Contacts*
Stefano Malaisi

www.malaisi.com 
www.malaradio.com 
stefano.mala...@gmail.com 

Mobile: +39-3356365644