Subject RE: [firebird-support] Problem slow sorting/distinct in Firebird
Author Leyne, Sean
> 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).