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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users