Subject 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
Well ... thank you but ... it was not a problem in older 2.5.x versions. But I also tried with:

select "PROC" from "PROC" where exists (select 1 from ....

But it also needs 24 minutes.

I know it is better a join, but in my queries it is possible to check "IN" up to 18 other sub-queries, so I have to use a way like this.

24 minutes is not acceptable for checking 46k records even if we do that one by one.

And as I said, under older 2.5.x it works very fast.