SQL Server Performance

RAIDb: Redundant Array of Inexpensive Databases

Discussion in 'Forum Announcements' started by gaurav_bindlish, Sep 12, 2003.

  1. gaurav_bindlish New Member

    gaurav_bindlish, Sep 12, 2003
    #2

  2. Luis Martin Moderator

    No at all.

    Luis Martin
    Luis Martin, Sep 12, 2003
    #2

  3. Twan New Member

    me neither

    Twan
    Twan, Sep 12, 2003
    #2

  4. Argyle New Member

    Interesting concept with built-in partial replication etc. I wonder how performance is with more complex queries though and how it would work with triggers etc.

    You could quite easily build your own poor man's version data access layer that use say 5 connectionstrings and when a write occurs you write to all 5 databases (could be on different servers) and when a read occurs you could either on random pick the database to read from or have a bit more complex solution that keeps track of which database has most connections etc.

    /Argyle
    Argyle, Sep 12, 2003
    #2

Share This Page