I am creating an app that will out grow an int(10) unsigned for the id
field, ie. 4,294,967,295 records.
What are my options, I have looked at the GUID plugin that lets you use
a 32 char GUID, but I still want the id’s to be sequential, and (I
think) that the overhead of searching a varchar field will be too big
for such a large number of records.
It does not appear you can use a double as an autoincrement field in
MySQL. Maybe because it is a float? So that can not be used.
Im guessing there is some sort of pattern for this problem. My first
thought was to create a second id field and increment that every time
the first id field rolls over to zero.
To do this I would need to override the get/set methods for id in the
models I want to apply this to. Would that be the right way of going
about such a solution?
Many thanks, K.