Thank you I did that.
I have decided to use external files for that purpose.
My test for loading 1 million records takes 15 seconds.
This is great :-)) !!!

--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@k...>
wrote:

> rado_antloga wrote:
> > How can I change firebird.conf to get maximum speed
> > for inserting 1 million records. RAM is not a problem.
> > I was changing DefaultDbCachePages, MaxUnflushedWrites,
> > MaxUnflushedWriteTime but I could only improve speed
> > for about 3 s. I could insert in MSDE with OLEDB rawset
> > in 17 seconds. With FB it takes 1 minute 22 seconds.
>
> Turn the forced writes off. You get basically the same thing as

with

> MSDE (speed and no certainty ;)
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net
> http://www.flamerobin.org