Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    29

    Unanswered: Performance of system

    Hi,
    I am developing an editorial system(MS-SQL). There are a public part(frontend for reader) and an editorial part (backend for editor, admin,...).
    The public part of system will be used approximately 1000 acesses/s.

    A possible solution:
    I solve whether I have to use two databases:
    1.DB all data
    2.DB with data for frontend

    acesses...............trigers
    --------->2.DB <----------1.DB

    or more of databases or else?

    The purpose is, a reader should have good response that the reader don't wait.

    Could you give me any advice ?
    Thanks
    Last edited by Perseus; 05-17-07 at 06:33.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    one database

    make sure all tables are properly indexed for performance of your main queries
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2005
    Posts
    29
    and is there any at least one reason for more database ??

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    separate database can be backed up and recovered separately
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •