Subject Re: Import of > 1 mio. records
Author thomas_besand
> > Well anyway, I implemented the COMMITs on every 10000 writes, as Dan
> > and others proposed, so now Firebird grabs itself around 16k of
memory
> > and stays stable at that. If I take a look at the logfile, I can see
> > it's taking roughly 2 min/10000 records steadily. So this side begins
> > to look good.
>
> 16KB? Or 16MB? Maybe you should tune the PageSize and NoOfBuffers
- try
> PageSize=8KB and Buffers=8.000-10.000.
>
Aage: 16 MB obviously.

Where do I tune PageSize and Buffers?

vh
T. Besand