SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    May 2009
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    beginner - need a large? database site

    im working on creating a website that will include a geosearchable datbase (search entries within x miles). I expect to have 500K - 1M searchable items in this database. Can anyone offer some guidance on how large of a mysql databse i will need (go daddy only offers 200MB mysql databases for shared hosting) i'm very new to this technology so im also considering programs that will help create/manage the database.

    are there other webhosts that i should look at that will allow mysql databases larger than 200MB on a shared server? (i dont yet feel that i know enough to look into virtual or dedicated hosting). based on my above description will i even need a larger database? aslo go daddy says that i could have unlimited databases, but each one cannot exceed 200MB. is there a way to link them together to acheive the results i want

    (fyi , i keep referring to go daddy because i have used them before and as a complete beginner i felt that they did a good time walking me through problems over the phone)

    any other comments or suggestions would be appreciated.

    thanks

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2008
    Posts
    1,149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Most hosts don't explicitly limit the size of your databases. They just limit the size of your entire webspace, which includes your databases.

    By the way, are you going to look into MySQL's spatial extensions? It's better fit for storing geographical data.

  3. #3
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,875
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    If you select a web host that specialises in hosting rather than one that just offers a limited hosting option as a side business the way GoDaddy does then you ought to be able to get what you need even with shared hosting.
    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
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you enlighten us a bit more? What are you trying to do, exactly? I may be able to offer some help.

    bazz


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
  •