Hello!

I want to share this query with you to find out what can be the problema now with this query example:

The test database has PROC with 46k records and MOVI with 1200k records.

select “PROC” from “PROC” where “PROC” in (

select distinct "PROC"

                               from "MOVI"

                               where "MOVI"."TIPO" in ('1','A','B')

                                               and ("MOVI"."FECH" between '20190301' and '20190412')

                                               and "MOVI"."MIEM" = '15JMS45D7A'

                                               and "MOVI"."HECH" = 'N' order by "PROC")

In a test machine this query perfoms well when I try it with FIREBIRD 2.5.0 or 2.5.2 (less than 30 seconds). But when I test with 2.5.8 it goes to more than 24 minutes.

If I only do:

select distinct "PROC"

                               from "MOVI"

                               where "MOVI"."TIPO" in ('1','A','B')

                                               and ("MOVI"."FECH" between '20190301' and '20190412')

                                               and "MOVI"."MIEM" = '15JMS45D7A'

                                               and "MOVI"."HECH" = 'N' order by "PROC"

It takes 4 or 5 seconds.

What can be the problem with this query undewr 2.5.8?

Thanks a lot for any help!

Best regards,

Dany