Post reply

Performance hit for cross-db queries?

  • July 17, 2002 at 9:42 pm

    #79408

    Folks,

    Is there any additional performance hit for doing queries that join two tables in two different databases (on the same MSSQL server), above and beyond doing a comparable query for two tables in the same database?

    - Tom

  • July 17, 2002 at 10:05 pm

    #432949

    You will get an additional security check. However this is small overhead. The separate db should generate a separate thread for I/O, so it may make up for this.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • July 17, 2002 at 10:12 pm

    #432952

    Thanks!

    - Tom

  • July 18, 2002 at 6:59 am

    #432983

    Just as a affermation. We tested breaking a database into year databases but some reports are based on three years. Each contained at least 50000+ records and we saw no performance hit in comparison to a single DB.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • July 18, 2002 at 7:21 am

    #432990

    Antares686, thanks. That's excellent news. I hadn't seen any problems myself with our usage of this technique, but it's good to put the concern to rest.

    - Tom

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply