You could also just order by rowid desc -- you wont visit rows with a rowid greater than the max(rowid) when the outer query started, and creation overhead for a b-tree to handle the order by will be avoided.
--- Sent from Samsung Mobile -------- Original message -------- From: Simon Slavin <[email protected]> Date: To: General Discussion of SQLite Database <[email protected]> Subject: Re: [sqlite] Ongoing SELECT sees INSERTed rows. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
