On 5 Feb 2019, at 8:00am, Gerlando Falauto <gerlando.fala...@gmail.com> wrote:
> Thank you for your explanations guys. All this makes perfect sense. > I still can't find a solution to my problem though -- write a query that is > guaranteed to return sorted results, in some optimal way. Please state your table definition, and desired query including ORDER BY clause. Please also tell us whether the amount of space taken up by your database file is important. Then we will tell you how to make SQLite use an efficient way to arrive at your desired result. It's not possible for us to just tell you the answer. This will involve a few steps on your part of testing. So if you aren't already using the SQLite command-line tool, please install it and learn to run it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
