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