SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Aug 2002
    Posts
    385
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Do you actually use BIGINT column?

    Not sure if it's a standard column in all database but in Mysql there is a BIGINT column capable of having a max integer value of 18,446,744,073,709,551,615. Now that's a huge number right there, 18 gazzillion cents!

    I was wondering do you actually use this column type? What sort of applications would use this huge amount of numeric storage? All I can think of is a search engine (like Google) probably uses this to store their index of web pages. Aside from that I think all other apps are just fine with the good ol' INT column which is capable of having a max value of 4,294,967,295, or is it too low in real world?

    On another note, maybe Myspace and the like could use BIGINT too, hmmm...

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,077
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    I don't use it. The only uses that I can think of would be for forum post id numbers, forum thread id numbers amd PM id numbers, but even then the forum would have to be a huge one.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,871
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    I would recommend not using it unless you have numbers that actually are that big.

    Even where you hope that you may need to store numbers that big in the future you can always change the field type when (if) you start approaching the point where you need it and avoid the overheads of using the larger field until that time.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    the only time i've seen it (legitimately) used is when some data was stored as a bit mask field. i ended up re-writing it as a one-to-many relationship anyway because i needed to be able to search those attributes efficiently.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •