> 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