SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Is bigger, better?

    Hello,

    I've just finished (ok...almost), my first dynamic site and it relies heavily on a database. I have a GoDaddy account, and just noticed (oops!) that there's a 1 gigabyte allotment for each database. I truly have no sense of whether 1 gigabyte is a lot or REALLLY a lot. If each user will be supplying approximately 2000 English characters to be held in the database from my site, then how long until I'm in trouble?

    With that said, are there hosts out there with unlimited database sizes?

    Thanks!

    -Eric

  2. #2
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,031
    Mentioned
    152 Post(s)
    Tagged
    2 Thread(s)
    2000 characters, assuming a 1 byte encoding like ASCII or ANSII is ~2kb per user. 1Gb/2kb ~= 500 000

    So you can host about 500 000 users on that 1 Gb

    Assuming 2 byte characters like UTF-8 you can host about 250 000 users on that 1 Gb

    Generally speaking, if you're not facebook or twitter or anything in that order of magnitude, 1Gb for a database (provided you won't use it story binary data such as images) is A LOT!

    Rémon - Hosting Advisor

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by kreut View Post
    Is bigger, better?
    oh my goodness yes




    maneuverability is also important, though
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If I host 500,000 users, then at $30 buck a pop I'll have retired to the Caymans and I won't worry about the next poor souls who get some sort of "Database Overload Error".

    Thanks so much for allaying my paranoia.

    -Eric

  5. #5
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by kreut View Post
    If I host 500,000 users, then at $30 buck a pop I'll have retired to the Caymans...
    that just ain't gonna be enough


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
  •