Subject | RE: [firebird-support] Strange question time, how small can I make an empty database |
---|---|
Author | Alan McDonald |
Post date | 2006-03-15T04:26:29Z |
>a smaler empty DB? not likely - you've no doubt fiddled with the page size
> 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
>
to ge tit that small but the smallest page size is going to be a problem for
you anyway - depending on what you are storing. If all you data was made of
smallint columns then the smallest page size might work for you - anything
else and you'll find a larger page size peforms better.
sorry
Alan