On 2016-04-08 16:16, Ted Roche wrote:
On Wed, Mar 9, 2016 at 6:17 PM, mbsoftwaresolutions@mbsoftwaresolutions.com 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.