SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2007
    Location
    London, UK
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Which way Single or Multiple databases?

    Hi guys, I am building and in house web app that will be used by clients from different countries. Some of the functionalities and services is based on country of the client. My current design is to have one database for the application where the country field from the client_details table is used to filter clients by country when necesary.

    A friend proposes that a better option will be to have a seperate database for each country. In this case is he right and if so how can this inprove the overall application? Links will also be apprecaited where I can go and educate myself some more on such a design if its indeed a better choice.

    Thanks
    Prov. 13:20 - He that walketh with wise men shall be wise: but a
    companion of fools shall be destroyed

  2. #2
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,810
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    It really depends on what type of database you are using as to whether it will make a difference. For example mySQL does not allow all the same security options to be set within a "database" as some other databases do and so you'd need to split it into separate "databases" in order to add those levels of security. mySQL does store all those logical databases in the one physical database though.
    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="^$">


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
  •