Subject | Re: [firebird-support] Re: Import of > 1 mio. records |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-03-19T07:01:16Z |
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
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