On 25 Mar 2014, at 5:48pm, michal.pilszak <michal.pils...@o2.pl> wrote:
> Is there any parameter I can set to select another algorithm (e.g. another > algorithm of ORDER BY) and check its efficiency? You can tell SQLite to search for different rows or order them in a different order. But you cannot tell SQLite to use a particular algorithm to do those things. SQLite decides how to obey your instructions itself. The best thing you can do is to CREATE an INDEX ideally suited to your SELECT command. If your database is large and you are concerned about how long your operations may take you might like to execute the ANALYZE command after you have INSERTed your data in the database and CREATEd your INDEX(es): <http://www.sqlite.org/lang_analyze.html> Hope this helps. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
