--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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
>
> the default page size has changed - you can manually set the page

size back

> 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

Thanks Alan, this is good to know. This may also explain the
difference in speed - we pull in 80MB of data in a migration (300-400k
records), which used to take 50+ minutes and is now only 30 minutes
(however some queries seem longer ... maybe).

Anyway, I've been looking on the ibphoenix site for docs on
strategy/methodology for choosing the optimal paging size. I couldn't
find one (maybe I missed one) - do you know of any docs/links covering
this?

Thanks again
Phil