Subject Re: [firebird-support] Re: Maximum speed for insert with embedded server
Author Milan Babuskov
German Gentile en Listas 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?

AFAIK, it depends on the operating system... whenever it decides to
flush HDD buffers. Generally, using forced writes = off is not such a
bad idea if you have stable power supply, operating system and server
dedicated to Firebird, so you're sure nothing else would intervene.

However, I run all my systems with forced writes on. I like to sleep
careless at night ;)

Milan Babuskov