>>In order to implement the ORDER BY clause, SQLite reads the entire result set >>into memory and sorts it there. When your result set gets very large (13000 >>rows) and each row uses in excess of 1KB or memory,this is apparently causing >>your machine to thrash.
If an index exists on the same column that Order By is used, does this still result in reading the entire result set? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 17/08/2005