andyg;436004 Wrote: > On Jun 27, 2009, at 9:30 PM, gharris999 wrote: > > > > > Andy: FYI: on a clear and rescan, I don't think the starting id > column > > values in the db tables are getting reset to 1. E.G: my genres > table, > > which has 39 records, starts at id==138; tracks, which has 47395 > > records: 1st id == 189507. > > > > I don't what the largest value that a INTEGER PRIMARY KEY field can > > hold. If it's 64 bits, I suppose that this isn't really a problem. > > > I'd > > have to rescan, what...389 trillion times before the field > overflowed? > > > > Anyway, this does seem to be different from how the mysql wipe and > > rescan worked. > > http://www.sqlite.org/autoinc.html > > It may be fixable, but probably not worth worrying about. Hummm...signed. OK, make that 194 trillion rescans.
-- gharris999 ------------------------------------------------------------------------ gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=64981 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
