On 28 Aug 2010, at 4:24pm, Max Vlasov wrote: > I don't know whether my posts have a delay with delivery (replied several > hours ago to the discussion you mentioned), but actually I tested 100 rows > before and after with a similar query (ORDER BY LIMIT) and it definitely > shows that sqlite saves time and doesn't go further. Do you have reason to > think that it should go to the end?
Thanks Max. There was a thread where someone suggested the opposite: that the LIMIT clause operated to trim results which had already been found. It worried me because I have been assuming that LIMIT meant that SQLite didn't have to search the entire table. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users