On 30 Nov 2013, at 10:24am, George <pinkisntw...@gmail.com> wrote: > I have noticed that when I order using just one column then the query is > very fast, because no TEMP B-TREE is used. When I add the other columns > then TEMP B-TREE is used and the query is very slow.
Do you have indexes on those four tables ideally suited to the query you're executing ? Think about how you, as a human, would need to look things up on each table to satisfy your JOIN and ORDER BY clauses. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
