title: What is the best way to make an auto increment ID's with large data?
body: <p>I just want to know what would be the best way or approach to implement an auto increment ID with large amount of data in a database.</p>
  
  <p>My table would actually contains at least hundreds of thousands of data which will be tagged by their unique ID's.</p>
  
  <p>I'm thinking of an alphanumeric ID's which contains prefix at the beginning followed by integer. I am considering the number of characters that should be made but not sure if it will cater even the data will populate more.</p>
  
  <p>Ex of ID I'm thinking is IA00001 then will be incremented by 1 would be IA00002 and so on.</p>
  
  <p>Is it just OK?</p>
  
  <p>I need your suggestions please.</p>
  
  <p>And thanks for advance for any suggestions.</p>