Hello, Sorry, I had two times the same metadata added ;-)
CREATE TABLE TREE3 ( IDLINK Integer NOT NULL, LINKTYPE Integer, IDITEM Integer, ITEMTYPE Integer, IDTARGETLINK Integer, NODEPOSITION Integer, NODELEVEL Integer, IDLAYOUTDATA Integer, IDTEMPLATE Integer, ACTIONDATE Integer, MARKET1 Integer, PRIMARY KEY (IDLINK) ); CREATE INDEX IDX_TREE3_2 ON TREE3 (IDITEM); CREATE INDEX IDX_TREE3_3 ON TREE3 (MARKET1); CREATE INDEX ITREE13 ON TREE3 (IDTARGETLINK,NODEPOSITION); CREATE INDEX ITREE53 ON TREE3 (IDITEM,ITEMTYPE); An vanderLinde --- In [email protected], "Leyne, Sean" <Sean@...> wrote: > > > > > 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 >
