no idea ? do you thing it's could be a bug in firebird (2.5) ? 1 second to retrieve on record by his primary index seam very much too long :( and even if their is no record founded it's take 1 second to return :(
--- In [email protected], "nathanelrick" <nathanelrick@...> wrote: > > hello, > > the table : > > CREATE TABLE DESCRIPTIONS > ( > IDObj VARCHAR(15) NOT NULL, > type SMALLINT NOT NULL, > Lang VARCHAR(3) NOT NULL, > Descr VARCHAR(10000), > PRIMARY KEY (IDObj, type, Lang) > ); > > With around 40 millions records > > now the query : > > select Descr From DESCRIPTIONS where (IDObj='XXX') AND (type = 1) > > => 1200 ms to return only one reccord :( > the speed is the same if xxx not exist ! > > the plan used: > PLAN (DESCRIPTIONS INDEX (RDB$PRIMARY135)) > > what is wrong ? > > on some other table with around the same number of rec but no VARCHAR(10000) > field then the return is in around 40 ms ! >
