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 firebird-support@yahoogroups.com, "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 !
>