Rado Antloga wrote:

> 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 :-)) !!!
>

With that option, when the databse will write the changes to disk/
Is that time under config?
TIA

> --- 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
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> click here
> <http://us.ard.yahoo.com/SIG=129fveikn/M=298184.5285298.6392945.3001176/D=groups/S=1705115386:HM/EXP=1092319699/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351>
>
>
>
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>