Subject | select first 1 id from table order by id descending to slow |
---|---|
Author | martinknappe |
Post date | 2006-05-23T15:19:51Z |
hello
i'm having the following problem:
i found out that
"select first 1 id from table order by id descending" (in order to
select the last record) is *WAY* slower than "select first 1 id from
table order by id ascending" (in order to select the first)
i'm using firebird 1.5
i've read in fb 2 there's this rows command; will it be faster with
that one? I'm new to databases and i'm reluctant to install an
unstable but if this would speed it up, i'd have no choice..
thanx,
martin
i'm having the following problem:
i found out that
"select first 1 id from table order by id descending" (in order to
select the last record) is *WAY* slower than "select first 1 id from
table order by id ascending" (in order to select the first)
i'm using firebird 1.5
i've read in fb 2 there's this rows command; will it be faster with
that one? I'm new to databases and i'm reluctant to install an
unstable but if this would speed it up, i'd have no choice..
thanx,
martin