--- In firebird-support@yahoogroups.com, "Sean Cross - CRM"
<sean.cross@...> wrote:

>
> I am considering using firebird for my next project. This will use

a number of databases. As size is important, I would like to have
the databases as small as is practical. When I create an empty db
file, it is about 600k which is too large for my purposes. After
playing with the creation sql I have got it down to about 240k. Is
it possible to create a smaller db than that?

Perhaps you can give some more details on why the empty database must
be so small? Is the requirement that it must stay small once you
start filling it with data? If so you may find the MGA starts to bite
you. Old record versions remain until garbage collection, and updates
add new record versions (as do inserts and deletes). File size is
never shrunk (but will be reused as required).

I have a database with over 100 tables, over 100 SP and triggers on
most tables, and after backing up (metadata only) and compressing was
92K.

Adam