Subject | RE: [firebird-support] 'Empty' Database much larger on newer version of Firebird |
---|---|
Author | Alan McDonald |
Post date | 2005-05-16T07:18:38Z |
> Hi, we had Firebird 1.5.0.4306 running on windows XP for a long timethe default page size has changed - you can manually set the page size back
> during project development. When we created a new database it'd be
> 250k, and then add 115 tables (about 650 columns) and a few dozen
> reference values, the database is 3.7MB. Ok.
> We finally updated to Firebird 1.5.2.4731. After this, when we create
> a new empty database it's 2.1MB and after adding the
> tables/columns/reference values, the database is 14MB!!
> I've built a new database several times always with the same result.
>
> Can anyone explain whether I've missed something, or do the newer
> versions of Firebird simply require more disk space? Going from 3.7MB
> to 14MB is really noticable. Especially if you wanted to download this
> via the internet (modems would take ages).
>
> I know 14MB doesn't sound like much, but we're installing this on a
> wide range of hardware, and we're also looking for small footprint and
> speed, so this is important to us.
>
> Thanks
> Phil
but a larger page size than the earlier 1024 has always been beter for most
cases.
create a new empty database in both environments by specifying page size and
you should get the same empty database
Alan