Re: [firebird-support] Re: Drop table safe when other users are active?

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

Re: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

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

ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

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