Subject Re: Problem slow sorting/distinct in Firebird
Author vanderlinde81
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 firebird-support@yahoogroups.com, "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
>