| Subject | Re: [firebird-support] Re: very slow commit |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-02-09T19:07:30Z |
svanderclock wrote:
page cache, so until you commit, nothing goes to disk, then
everything goes at once. If you're using a modern Firebird,
check the MON$ tables for I/O statistics before and after
commit. If you're seeing only reads, fetchs, and marks before
commit and tons of writes afterward, that may be a clue.
Good luck,
Ann
>All I can guess is that you've got a huge (and uncontested)
> but in my case, why the insert is very fast and the "commit" is sooo long (100 times more longer than the insert) ??
>
page cache, so until you commit, nothing goes to disk, then
everything goes at once. If you're using a modern Firebird,
check the MON$ tables for I/O statistics before and after
commit. If you're seeing only reads, fetchs, and marks before
commit and tons of writes afterward, that may be a clue.
Good luck,
Ann