> Hello,
>
> I have a problem with the speed of a query in Firebird. The slowness is in the
> sorting and distinct.
>
> If I try the query in MySQL then he is one second faster.
>
> Firebird -> 1,3s a 1,6s
> MySQL -> 0,3s a 0,4s

You forgot to post the schema/indexes for the TREE table (you posted Article3_1 twice).


Sean