Subject Re: [firebird-support] Why write async is bad ?
Author Dmitry Kuzmenko
Hello, Vander!

Tuesday, January 10, 2012, 2:42:33 PM, you wrote:

VCS> when i setup write async to true, it's mean the the database will store
VCS> in memory the write
VCS> and after several update (5 by default?) all the write will be flush to
VCS> the disk.

before writing about "5 updates" here, please read comments
in firebird.conf about MaxUnflushedWrites and MaxUnflushedWriteTime.

VCS> The main drawback, is that all the write are flush to the disk using the
VCS> current connection thread


VCS> it's mean that if i m the unlucky guy to commit the 5th update then my
VCS> commit will be more slower because
VCS> it's will also commit all the previous update.

why do you have so strange assumptions? You've made practical tests?
Or, if this is just a theory, what it is based on?

VCS> i was thinking that it's a separate thread that was responsible to flush
VCS> to disk or i m wrong?

what thead do you speak about, and in what Firebird architecture -
classic or superserver?

Dmitry Kuzmenko,