mysql q
mysql q
Out of context: Reply #3
- Started
- Last post
- 5 Responses
- mike0
the int type will hold a number as high as 2.1 billion. if you plan to have more than that number of records without any sort of archiving I would say you should be looking more into performance issues rather than field sizes.
if you don't declare the size of your field it will grow to meet the size demand, so you can go up to 2.1 billion if necessary. also, it would be bad to map an int type to a varchar type. string lookups are much slower than int comparisons.
http://www.mysql.com/doc/en/Numeā¦
hope that helps.