Nicolas Boullis wrote: > I have a program that does mostly? SELECT requests, and it is very > slow. But I then figured out that, if I rebuild my SQLite database > without PRIMARY KEY/UNIQUE constraints, the program runs much faster > (no measurement yet, but I?d say at least 10? faster).
SQLite does not keep statistics automatically. Run ANALYZE. If that does not help, we'll have to look at the actual queries (and their EXPLAIN QUERY PLAN output). Regards, Clemens
