On 5.11.2015 19:38, setysvar setys...@gmail.com [firebird-support] wrote:
>
> Den 05.11.2015 12:12, skrev Josef Kokeš j.ko...@apatykaservis.cz
> [firebird-support]:
> > SELECT COUNT(*)
> > FROM a_complex_view
> > WHERE field1=1 AND field2<>2
> > AND key_field IN (SELECT key_field FROM
Hi!
I wonder: Was there any change in FB 2.5.4 which would slow down
processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I
have been performing tests because a user of mine complained about slow
speed of my database, and found out that my query in the form of:
SELECT
Den 05.11.2015 12:12, skrev Josef Kokeš j.ko...@apatykaservis.cz
[firebird-support]:
> Hi!
>
> I wonder: Was there any change in FB 2.5.4 which would slow down
> processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I
> have been performing tests because a user of mine complained