On 2016-04-08 16:16, Ted Roche wrote:
On Wed, Mar 9, 2016 at 6:17 PM,
<[email protected]> wrote:
...I did
NOT want to use auto-increment keys in the tables because I wanted to
have
more control over them during data-entry, so basically, I can create
all
kinds of records and then at save time AND ONLY THEN do I want to
store the
actual data (and that's why AUTOINC keys wouldn't work).
Fun Fact: If you were to create 1000 PKs a day and throw them away,
and you worked 365 days/year, you would run out of 4-byte integers in
11,767 years.
Another trivia: Didn't Twitter have a problem with their system because
they were using AutoInc keys?
Of course, if you were to create GUIDs, the universe would likely end
first.
I know I know...and it's currently setup that way.....it's just the
miser inside of me trying to optimize as much as I can. OCD.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
