On Tue, Feb 11, 2014 at 11:05 AM, Paul Beach <pabeach@...> wrote:

> - How should the output of fb_lock_print interpreted in this case? Are
> these numbers "wrong" in some sense? Can they be improved by some
> parameter tuning?>>
>
> Rejects = Lock requests that cannot be satisfied.... no big deal
> No wait locks? Engine locks? I wouldn't worry about it.
>
> Looking at your Lock Header - it looks fine. Your problem is elsewhere.
>
Another thing I noticed since my original e-mail (and after reading a few
chapters in a Firebird book) is that "the gap" between OIT and OAT can be
farely large (500 000 +) during the slowdowns, though there is no linear or
polynomial correlation between the refenrece query's execution time and the
size of the gap:

[image: Inline image 1]
(blue is the execution time of the reference query (left side y axis),
purple is the gap (right side y axis))

As I read, gap is not the cause of the slowness just an observable result
of transactions that might result in slowness. So now I think this is the
area that should be investigated further. It seems that to further analyze
this I'll need some of the advanced Firebird tools.
--
Zizi

"...nálatok a cégnél múltból nagyon sok van..."


[Non-text portions of this message have been removed]