Igor Tandetnik wrote: > B V, Phanisekhar <[EMAIL PROTECTED]> wrote: >> I wanted to know the algorithm used by sqlite to generate the new >> rowid. Assume there can be N distinct rowid's possible, now insert N >> records, followed by random deletion of some records. Now what rowid >> will be assigned to a new row that is added? > > http://www.sqlite.org/autoinc.html > > Note that N=2^63-1. A typical application would have to work for a very > long time to create N records. > > Igor Tandetnik
Interesting reading... If a large amount of records are DELETED and then a VACUUM is run do the rowids change? -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users