volomike/Faster — Issue #18: Improve getNewID() with Trigesimals
Author: volomike
Created: 2011-11-04 22:47:01+00:00
State: open
Labels: Feature

The current getNewID() strategy in the Faster_Data class has a limit of around 46 million. You can do your own math, but I came up with around 46 to 47 million as I analyzed that routine. By using a Trigesimal with a dash, however, we can use those same 8 digits (including the dash position) and get a number range of 21 billion. I document this here:

http://voloreport.com/the-case-against-mysql-autoincrement-columns

Some sample outputs of this would be like:

```JRS-81MH
6VJ-MDH2
F8Q-6Z06
BXL-PCLN```