Cross Database Query 1

[StoneDeCroze]

Hi all,
I am using MS SQL 7 with two databases

Question: is there a performance issue in creating a view in one datase base that accesses data in another?

i.e. is SQL quicker doing this from Database1 or Database2 or is there no difference?

SELECT * FROM database1.dbo.DATATABLE

I have done some simple tests checking stats I/O and time and there doesn't seem to be any difference but ....

Thanks
Peter

 

[JamesLean]

I think you've answered your own question... ;-)

--James

 

[StoneDeCroze]

Thanks James.

But to get your Magenta star are you saying for sure that there is no siginificant overhead?

I am not too willing to trust a few hokey tests I threw together in 10 minutes ( and I don't have a day I can put aside for some serious testing ).

Ta
Peter

 

[JamesLean]

No, there's no difference. (Obviously if you're talking about a different server then you would probably see a difference).

--James

 

[StoneDeCroze]

One Magenta star coming you way.

Thanks