Subject | Re: Import of > 1 mio. records |
---|---|
Author | thomas_besand |
Post date | 2005-03-19T05:53:24Z |
> > Well anyway, I implemented the COMMITs on every 10000 writes, as Danmemory
> > and others proposed, so now Firebird grabs itself around 16k of
> > and stays stable at that. If I take a look at the logfile, I can see- try
> > 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
> PageSize=8KB and Buffers=8.000-10.000.Aage: 16 MB obviously.
>
Where do I tune PageSize and Buffers?
vh
T. Besand