On 2014-08-18 14:51, Aldo Caruso [email protected] [firebird-support] wrote: > After that I noticed that some massive updates ( 100K records ) took > nearly 5 minutes, whereas with async writes it used to take 10 seconds.
Of course, we don't know how much work actually took place during that 10 second period when forced writes were off. Could be that very little of the update was actually on disk at that point. So do you consider the massive update actually done at that point? Also while forced writes are off, when is all that "5 minutes" worth of work actually done? When the database is closed? When the server was shut down? Thats's the problem with forced writes being off - you never know. -- Cheers! Rich Saunders
