On 6/29/06, Jens Miltner <[EMAIL PROTECTED]> wrote:
Is there any way to improve the ORDER BY performance for joined queries? From your answer that the intermediate results are sorted, I take it no index won't ever be used when using ORDER BY with a join query?
You can use the explain command to optimize queries: http://sqlite.org/lang_explain.html You might read through the optimizer notes to see how it works rather than trust to my poor memory: http://sqlite.org/optoverview.html -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
