[firebird-support] Yahoo broken again?
I've just been trying to access the list on-line, but it would seem yahoo have broken everything again? Keeps coming back that the redirect can not complete? Is the 'VISIT YOUR GROUP' below working for anybody? -- 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
Re: [firebird-support] Yahoo broken again?
On 27/06/14 09:16, Lester Caine les...@lsces.co.uk [firebird-support] wrote: I've just been trying to access the list on-line, but it would seem yahoo have broken everything again? Keeps coming back that the redirect can not complete? Is the 'VISIT YOUR GROUP' below working for anybody? OK - logged out of yahoo an back in and I could get at groups again :) -- 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
Re: [firebird-support] Database Too Large.
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
Re: [firebird-support] Database Too Large.
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 http://www.malaisi.com www.malaradio.com http://www.malaradio.com mailto:info.malara...@gmail.comstefano.mala...@gmail.com mailto:stefano.mala...@gmail.com Mobile: +39-3356365644 http://www.facebook.com/profile.php?id=743074774 http://twitter.com/StefanoMalaisi http://itunes.apple.com/it/app/malaradio/id363385857?mt=8
Re: [firebird-support] Database Too Large.
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] Yahoo broken again?
At 08:16 p.m. 27/06/2014, Lester Caine les...@lsces.co.uk [firebird-support] wrote: I've just been trying to access the list on-line, but it would seem yahoo have broken everything again? Keeps coming back that the redirect can not complete? I don't get that at all. Is the 'VISIT YOUR GROUP' below working for anybody? Yes - albeit it redirects to https://groups.yahoo.com/neo/groups/firebird-support/info My default browser is Firefox 30.0 on Windows 7, and similar on Mint 13. Helen
Re: [firebird-support] Database Too Large.
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 database_path that's all. Regards, Alexey Kovyazin IBSurgeon
Re: [firebird-support] Invalid argument in EXECUTE STATEMENT - cannot convert to string
On 26-6-2014 10:14, Tim Ward t...@telensa.com [firebird-support] wrote: It was in fact elementid being null. Having discovered this I was unable to tell the list as a reply to my original message because this list doesn't seem to send messages to their originator. The e-mails I send to the mailinglist also get delivered to my mailbox. Maybe there is some config option for this on the Yahoo Groups website, but I haven't found it yet. Mark -- Mark Rotteveel