On 7 Feb 2011, at 6:48pm, Sven L wrote: > Yes, this is what I have read on the net too. But, tests show that without > the sqlite_stat* tables, my queries are ridiculously slow (probably unwanted > table scans etc). > Real-life data... can't I simply take my real-life database and extract the > data in sqlite_stat*?
I suppose you could take an existing database, do "ANALYZE", then "DELETE * FROM ..." for all TABLES. > Btw, this command produces nothing even though the table does contain several > rows: ".dump sqlite_stat2" Try "SELECT * FROM sqlite_stat1". stat2 appears only if you have a compilation option turned on. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
