0, across approx 20 databases, ranging from small 3 table schemas, to a couple of ERP systems using 120+ tables.
Thanks, Chris On Fri, Mar 16, 2018 at 4:09 PM, R Smith <ryansmit...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users