On 2014-08-18 14:51, Aldo Caruso aldo.caruso@...
[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