[firebird-support] garbage collect
Hi I'd like to do my backup without gc and then do the gc separately - is there any effective difference between doing gbak with gc and gbak without gc and then gfix -sweep Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
[firebird-support] I need a Firebird DB Documenter Utility
I've been designing FB DBs for years just using FlameRobin. It works great for what I need to do, and I can use Delphi's modeler to show an ERD to fellow developers when necessary. However, to explain how the DB relationships work to a customer is still a challenge. Customers need a more aesthetically pleasing output. The output has to fit nicely on a paper analog display (.pdf, 8.5 x 11 pages) I need a utility that will do the following: - Automatically read my existing Firebird 2.5x DB and create an ERD - ERD must include Table and Field descriptions that I entered into Firebird - Must be able to output a report suitable for presentation to a customer who only understands paper analog reports. (Example, each page is for one table, interconnecting lines are abbreviated to arrows, nice fonts and colors) - ERDs are a bit overwhelming for people not used to reading them. Remember that there is no scroll capability on a piece of paper, so it's not good to have an ERD that is the equivalent of 50 x 100 in size, for the target audience. Does anyone have any suggestions? Commercial license or free is ok. Thanks in advance for any help you can provide.
Re: [firebird-support] garbage collect
On Apr 5, 2015, at 11:23 AM, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: is there any effective difference between doing gbak with gc and gbak without gc and then gfix -sweep The only differences (that I can think of) are caused by concurrent actions. If you garbage collect during backup, the sweep can remove new garbage created while the backup ran. Imagine that garbage collection takes enough time for fine thousand transactions to complete and each of those transactions makes three record versions obsolete. Neither gbak nor sweep can remove record versions made obsolete by the completion of a concurrent transaction. So if you backup without garbage collection, your backup is quicker, sweep starts sooner and takes longer so those 15,000 old record versions continue moldering in your database. If you backup with garbage collection and then sweep, the backup is slower, but the sweep starts later and can remove those unlovable record versions. Sort of a wash, rinse, repeat thing - if that phrase means anything to those who aren't elderly Americans. Cheers, Ann From sunny Sint Maarten.
RE: [firebird-support] I need a Firebird DB Documenter Utility
I do it the other way around. I use Sparx-Systems’ Enterprice Architect to document/capture my ERD and generate the DDL from there. The diagrams are all UML and makes provision for documentation as part of the table and column specifications. EA can also generate documentation and even an interactive HTML/JS html pages to drill throughout the model. My entire application’s design from tables to class, flows etc are captured in the model. That way everything is in one place and not bits pieces in various apps. EA can also reverse engineer your DB From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 05 April 2015 08:43 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] I need a Firebird DB Documenter Utility I've been designing FB DBs for years just using FlameRobin. It works great for what I need to do, and I can use Delphi's modeler to show an ERD to fellow developers when necessary. However, to explain how the DB relationships work to a customer is still a challenge. Customers need a more aesthetically pleasing output. The output has to fit nicely on a paper analog display (.pdf, 8.5 x 11 pages) I need a utility that will do the following: - Automatically read my existing Firebird 2.5x DB and create an ERD - ERD must include Table and Field descriptions that I entered into Firebird - Must be able to output a report suitable for presentation to a customer who only understands paper analog reports. (Example, each page is for one table, interconnecting lines are abbreviated to arrows, nice fonts and colors) - ERDs are a bit overwhelming for people not used to reading them. Remember that there is no scroll capability on a piece of paper, so it's not good to have an ERD that is the equivalent of 50 x 100 in size, for the target audience. Does anyone have any suggestions? Commercial license or free is ok. Thanks in advance for any help you can provide. [Non-text portions of this message have been removed]