| Subject | Re: [firebird-support] slow order by performance on a view |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2013-07-24T07:31:31Z |
On Wed, 24 Jul 2013 04:22:33 -0000, "ttt_dev" <ttt_dev@...>
wrote:
Mark
wrote:
> hi, thanks for any help with this...descending.
>
> i need to select the first x records from a view ordered by ID
>becomes
> when the view does not contain an ORDER BY statement then the query is
> rapid. however when i put an ORDER BY statement in then the query
> extremely slow (from 1 sec to nearly 1 min).Which version of Firebird?
>
> i tried to add a descending index on the docs_search_terms table then
> recomputed the indexes afterwards with little effect.
>
> i will paste the SQL and the plan below. i would be grateful for any
> assistance with this. thanks.
Mark