MySQL Forums
Forum List  »  Newbie

Best unique ID type for huge amounts of data
Posted by: Greg Knox
Date: April 11, 2019 08:06AM

I'm looking to create a table that can store billions upon billions of records.

I've read that if I use an INT as the unique ID then I'm limited to the max value of an INT for my records. If this is true, what's the best option for storing unique IDs that will allow for massive amounts of data?

Would storing the IDs as GUID be a possibility or are there other types that are more efficient?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Best unique ID type for huge amounts of data
April 11, 2019 08:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.