Den 2019-05-26 kl. 13:28, skrev hv...@users.sourceforge.net
[firebird-support]:
>
> > A few years ago we suffered Firebird corruption and got it fixed with
> > the help of IB Surgeon. I was told at the time that dropping tables
> > while other users were connected was the probable cause, an
Hello Karol; here you have both query plans, excecuted over same FDB file, on
the same machine:
-
FIREBIRD 2.5.0:
-
Preparing query: select
"PROC"."PROC","PROC"."CARP","PROC"."ACTO","P
Hi
Do you use FB3 Super Server or Classic?
What value of PagePuffers and PageSize?
I see big reads but also big indexes reads but fetches are lower.
There is also one plan difference
MOVI INDEX (MOVI_PROC) vs MOVI INDEX (MOVI_PROC, MOVI_FECH)
But i am intersted how this looks like at second run