Sean Cross - CRM 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?
>
>
>
> Regards
>
> Sean
> -----------------------------
> Sean Cross
> Systems Development
>
> CRM
> PO Box 230
> Napier
> Phone: 06 835 5868
> Mobile: 027 276 6439
> Email: sean.cross@...
>
>

Sean,

just tested when I back up the 600k empty database it becomes 512 bytes.
:o). I think it is small enough, but I am sure it has no pratical value.

I suggest you to create what you consider be the empty DB (any table you
want, the basic data on that table, etc.) then back it up, after that
zip it, I am sure it will be small enough for your needs.

Another option will be to send with your app the SQL script to create
the metadata and populate the tables, then create the database on your
customer machine using ISQL feeded by your script for example. Bu I am
sure the zipped backup will be small enough.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br