Re: [sqlite] Slow ORDER BY on INTEGER PRIMARY KEY

Setzer Sebastian (ext) wrote: Hi, it seems that Queries with ORDER BY (and a LIMIT-Clause to keep the result small) are quite slow if the ORDER BY is on an INTEGER PRIMARY KEY - column. If the ORDER BY is on a normal column for which I made an index, its quite fast. It doesn't help do create an ind

[sqlite] Slow ORDER BY on INTEGER PRIMARY KEY

Hi, it seems that Queries with ORDER BY (and a LIMIT-Clause to keep the result small) are quite slow if the ORDER BY is on an INTEGER PRIMARY KEY - column. If the ORDER BY is on a normal column for which I made an index, its quite fast. It doesn't help do create an index on the primary key (doesn'