Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scholin
Yak Posting Veteran
56 Posts |
 Posted - 2010-07-07 : 13:35:03
|
| I understand that this is a generalized question, but by adding multiple views, would one expect to see a "noticeable" performance hit? (of course I understand there could be a lot of other factors like type of joins, indexing, etc).The other question and maybe more directly to what I am fishing for, I have a medical web database with many tables. Some of my clients would like to get a read only access to their data. So I am thinking that the way to do this is with filtered Views.What are some thoughts here on how best to share filtered data from a remote server? Is there a clever way to do nightly syncs of filtered data?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-07 : 14:19:51
|
| night sync is a very good practise. you can also do log shipping between two instances or servers, depending on your capabilities. as for sync of data, prepare your tables in advance for your client and set the sync / logged database to be read-only. |
 |
|
|
scholin
Yak Posting Veteran
56 Posts |
Posted - 2010-07-07 : 20:36:59
|
Thank you both for you comments -this is helpful.Question relating to your comment quote:
set the sync / logged database to be read-only.
Can you provide or point me to more specifics on how to provide remote access to share a filtered view to different clients? This is all new territory for me. Thank you! |
|
|
|
|
|
|
Does multiple Views affect performance?