Dmitry Yemanov comments

Results 190 comments of


                                            Dmitry Yemanov

OuterJoinConversion parameter set to True decreases Firebird performance

What performance would be (in both FB versions) if the query is rewritten as: ```sql select T.NAZWA from TECHNOLOGIA T join OPERACJATECH OT on (T.ID_TECHNOLOGIA = OT.ID_TECHNOLOGIA) join OPERACJATECHBOM OB...

OuterJoinConversion parameter set to True decreases Firebird performance

And the performance numbers (execution time, number of fetches) were... ?

OuterJoinConversion parameter set to True decreases Firebird performance

Any chance to get a database to test against?

First ... Query valid without Space between Number and Column

IIRC, this is already fixed in #8564 (according to the description).

Query hangs when using forced PLAN that works automatically in Firebird 5

Column NOTA_FISCAL is missing in the table structure. And I failed to reproduce the issue with the steps provided, so a complete test case would be appreciated.

Query hangs when using forced PLAN that works automatically in Firebird 5

Downloaded, thanks.

Query hangs when using forced PLAN that works automatically in Firebird 5

I was able to reproduce the issue, it's being investigated.

Move blob search logic in Replicator into a new method to prevent code duplication

In the initial implementation (RDB v2.6 / v3.0) blob was replicated always if `master_priority` setting was enabled, otherwise only if blob was changed. This setting was not migrated to FB...

Performance degradation after ALTER INDEX ... ACTIVE

At least one of the reported issues is really a bug. I will look at others after resolving the first one.

Too long numeric hex literal silently converted to value 0 with an alias

23.05.2023 13:40, Adriano dos Santos Fernandes wrote: >> I already received the same question by people, "why this works"? So, >> people write it. But the question itself means they...