> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gerry Snyder > Sent: Wednesday, April 23, 2014 2:36 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] BLOBs and NULLs > > On 4/23/2014 10:21 AM, Drago, William @ MWG - NARDAEAST wrote: > > .... If I was sure I wouldn't be merging data I might use timer ticks > as my ID, but I'm not sure and I can't take the chance. > > > > -Bill > > Would it be possible to use INTEGER PRIMARY KEY AUTOINCREMENT for the > ID, and manually start each test station at an ID value a billion > larger than the previous one? Or whatever delta makes sense? Then > collision could never happen.
Sure, but why make it so complicated? I understand the desire to save space, but geez, we're talking about a few extra bytes per row in a database that will be used for low volume widget testing on PC's with terabyte size disk drives. GUID vs. Int is not going to make a difference in this case. > And, as a possible bonus, the ID would > indicate which station the row came from. I'm storing computer name and hard drive serial number, so that's already taken care of. > > Gerry > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users