Just a reminder that the automatic_index pragma does not create permanent indexes, it's for places where SQLite feels that "hey, if I take the time to create this temporary index then it'll save me more than that time during the rest of this one query." Those indexes get wiped at the end of the query. So in a bad case then you're creating a temporary index every time you run the query. There're some good notes on that at http://www.sqlite.org/optoverview.html#autoindex
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Laura BERGOENS Sent: Wednesday, September 07, 2016 1:09 PM To: SQLite mailing list Subject: Re: [sqlite] Query time execution difference between my application and SQLiteBrowser quote:"Now, you need to create a primary/foreign keys and indexes on the tables you are creating. Then the execution time will improve even more" I will probably try that tomorrow and I'll tell you how that goes, but I'm not sure if that will be very effective since i activated the PRAGMA to create indexes automatically. I'm guessing it has created some (hopefully). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
