SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: multiple databases vs perfomance

  1. #1
    SitePoint Enthusiast Mary_Itohan's Avatar
    Join Date
    Dec 2004
    Location
    e-Planet
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    multiple databases vs perfomance

    hello
    is there any significant advantage or disadvantage having multiple databases, owing to the fact that we have high transactions to our application

    please if you can let me have references

    Mary
    KISS - Keep It Simple Stupid

  2. #2
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,462
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    advantage of single database -- easier to produce stats on all databases

    advantage of multiple databases -- one goes down, the others aren't affected
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

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
  •