Across 8 production systems and about 120 SQLite DBs for us - Not a
single AUTOINCREMENT - so 0 .
I have to confess though, there are less critical places where we use
the ability of SQLite to insert and automatically incremented INT
primary keys (so Non-AUTOINCREMENT keys), in case that is relevant to
the knowledge you seek.
On 2018/03/16 5:37 PM, Richard Hipp wrote:
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
Private email to me is fine. Thanks for participating in this survey!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
