On Wed, May 13, 2009 at 7:40 AM, Matt Sanford <m...@twitter.com> wrote:
> > Make that *signed* integer. Writing too many emails at once, sorry. That would be the MySQL (and any 32-bit OS) maximum signed integer, or 2,147,483,647, I'm assuming. So if we're using an unsigned INT in our tables, we're fine for a while (months?) - status IDs will always be positive, right? And BIGINT, especially unsigned, is safe for a long, long time? Just curious... does this mean Twitter really is closing in on 2 billion tweets, or were some IDs skipped? Is there a prize for whoever posts tweet number 2 billion? ;-) Nick