[sqlite] Weird (slow) TEMP B-TREE ORDER BY

[Richard Hipp]

On 3/11/15, Dinu Marina <dinumarina at gmail.com> wrote:
>
> Sorry to be a pain, but does anyone have an idea about this issue?
>


Maybe try:

   CREATE TEMP TABLE xyz AS SELECT .... -- query without the ORDER BY clause;

Followed by:

   SELECT * FROM xyz ORDER BY ....;
   DROP TABLE xyz;

does doing it that way run faster?



-- 
D. Richard Hipp
drh at sqlite.org