I have a query that is used to populate a table in my website. The query joins 4 different tables and returns around 10 columns, and I want to order on 4 of them, each of those 4 being on a different table. I also use a LIMIT clause for pagination.
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. Is there some way to avoid this TEMP B-TREE? Since I am using LIMIT 25, the database really only needs to order those 25 (or slightly more) rows. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users