2018-03-16 16:37 GMT+01:00 Richard Hipp <d...@sqlite.org>: > This is a survey, the results of which will help us to make SQLite faster. > > How many tables in your schema(s) use AUTOINCREMENT? > > I just need a single integer, the count of uses of the AUTOINCREMENT > in your overall schema. You might compute this using: > > sqlite3 yourfile.db '.schema --indent' | grep -i autoincrement | wc -l >
A lot less as I thought: 0 5 0 0 0 0 0 0 0 2 0 2 0 0 0 1 0 0 0 -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users