> If "order by" isn't used in a select statment, does the result records > ordered in rowid?
If you omit an ORDER BY clause, the order of the resulting data is undefined. It might happen to be ordered by rowid in some cases, but this is not guaranteed. (Might change in a future version, etc.) If you need to ensure a particular order, use an ORDER BY clause. The good news is that if you order by rowid / PRIMARY KEY, you likely won't see much (if any) performance drop, but you're guaranteed to get the order you want. The following "reverse_unordered_selects" pragma may be of interest: http://sqlite.org/pragma.html#pragma_reverse_unordered_selects ~Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
