On 9/7/16, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Sep 2016, at 3:10pm, Laura BERGOENS <laura.bergo...@imerir.com> wrote: > >> I guess I don't have further question regarding my issue, since I have the >> same time execution as with the sqlite3.exe tool, so there are no problems >> with my pragmas or whatsoever. > > Nevertheless, 100 seconds is a very long time for a query, and we can > probably improve on it if you're willing to include your "SELECT" command > and your schema. It might be something as simple as creating one additional > index. > > You might also try executing "ANALYZE" in sqlite3.exe and see whether that > speeds things up. >
+1 First run ANALYZE and then retry your query. Then run ".fullschema -indent" from the command-line shell and send us the output together with the complete text of the SELECT statement that is running slowly. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
