July 10, 2006 at 10:45 am
I just ported some code over to my new production machine which should be much faster than the staging server. I arranged the DBs a little differently for the sake of organization so one of the queries makes joines across three DBs where it used to all be in the same DB.
Its much slower now. Does having objects in defferent DBs slow things down?
I separated them based on recovery models. Two of the DBs dont need transaction logging and will have many bulk insert statements made against them. The third will have all the logic and metadata and needs backing up.
SQL 2012 Standard VPS Windows 2012 Server Standard
July 11, 2006 at 6:03 am
Technically a cross db query shouldn't be that much different to a single db query ( on the same server ). Make sure your indexing and query is spot on ( and make sure you've updated stats ) Make sure you fully qualify your query.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply