Subject Re: [firebird-support] Re: Import of > 1 mio. records
Author Pavel Menshchikov
Hello Thomas,

t> Where do I tune PageSize and Buffers?
You can change the database page size when you restore the database:
use -p[age_size] <n> switch with gbak (<n> could be 1024, 2048, ...,
16384) (or use some admin tool to restore the DB and to set that
property interactively).
BUFFERS is the database property, use gfix -buffers <n> ... to
modify the value. Note that there is a performance problem with the
value greater than 10000 (up to FB 1.5.x). Also most of admin tools
let you modify the value interactively.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com