Mensaje
De
14/12/2006 11:47:28
Mike Yearwood
Toronto, Ontario, Canada
Toronto, Ontario, Canada
a
14/12/2006 11:43:29
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Título:
Re: Add + 1 to code
Miscellaneous
ID de la conversación:
01177374
ID del mensaje:
01177642
Views:
18
Hey Greg
>Just my two cents on the AutoInc field -- I don't use it either.
>
>I have a routine that autoincrements using 0-Z (zero through letter Z). This gives 36 digits (Base 36) in each byte position (instead of ten). The field is a char field and I left pad the field with zeros (built into the autoincrement routine). This gives a much higher number of combinations in a smaller field; for a 5 byte field, a base 10 gives 99999 unique values, whereas, the base 36 gives 60,466,176 unique values (36**5 combinations).
Have you compared the timing of that versus generating a GUID?
>Just my two cents on the AutoInc field -- I don't use it either.
>
>I have a routine that autoincrements using 0-Z (zero through letter Z). This gives 36 digits (Base 36) in each byte position (instead of ten). The field is a char field and I left pad the field with zeros (built into the autoincrement routine). This gives a much higher number of combinations in a smaller field; for a 5 byte field, a base 10 gives 99999 unique values, whereas, the base 36 gives 60,466,176 unique values (36**5 combinations).
Have you compared the timing of that versus generating a GUID?