| 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 |
|---|---|
| Author | |
| Post date | 2019-05-24T22:03:20Z |
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.
Dany