Jump to content


Photo

running out of space?


  • Please log in to reply
4 replies to this topic

#1 Liquid Fire

Liquid Fire
  • Members
  • PipPipPip
  • Advanced Member
  • 806 posts

Posted 03 August 2006 - 05:19 PM

this is not a problem right now and don't think it will be in the furture but just thinking about it.  nwo i have a table with a id that is int(10), and none of them can have the same number.  i don't know ho wmany possible number are possible with that, i know it is very big, but what happen when i reach the last possible number, what will happen when i try to add one more after that?

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 03 August 2006 - 05:32 PM

int can hold upto a maximun of just over 2.1 billion entries - 2,147,483,647 to be exact. If you want to go bigger you can use bigint.

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 August 2006 - 05:33 PM

And if you use UNSIGNED, you get twice as many.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 03 August 2006 - 05:46 PM

Use UNSIGNED - assuming one db entry per second that gives us 130+ years to solve the problem
Legend has it that reading the manual never killed anyone.
My site

#5 Liquid Fire

Liquid Fire
  • Members
  • PipPipPip
  • Advanced Member
  • 806 posts

Posted 03 August 2006 - 06:03 PM

i guess i never really realized how many entries that is and that i really don't have to worry about it




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users