German Gentile en Listas wrote:

> 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/>.
> >
> >
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> click here
> <http://us.ard.yahoo.com/SIG=129lqt6hp/M=298184.5285298.6392945.3001176/D=groups/S=1705115386:HM/EXP=1092321547/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350>
>
>
>
> *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/>.
>
>

So?