Re: Design choice in the Use of SQl Server Views for ETL
- From: "Jeje" <willgart@xxxxxxxxxxx>
- Date: Sat, 18 Aug 2007 13:35:34 -0400
well... the impact depends on the complexity of your queries.
if your queries do large and complex joins, then the impact can be important on the M server. so going through MCopy is a good idea.
moving data from M to MCOPY or M to ODS (using simple views) should results on the same performance, but the design is simplified.
compare the price of maintaining MCOPY versus adding memory and disks on the M server. adding disks and memory can improve the end user access and your design, so everybody is happy.
"RK" <RK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7884C0B1-CE23-441A-8805-D1DFEDA5B7F2@xxxxxxxxxxxxxxxx
Hi Jeje,.
Wont the use of views based in the database M cause performance problems.
For instance if I were to use normal data views every time a view is run as a
part of the ETL, its going to run a query on the M database further
constraining performance of the already constrained database M.
Using indexed view directly on database M in that server would mean the
overhead of having to maintain the data in the indexed views by the updates,
inserts and deletes happening in the underlying tables in database M means
again potentially poor response times on the application runnng based on
database M.
Hope you understand my concern.
Thanks
RK
"Jeje" wrote:
your solution M --> MCOPY --> ODS appear to be a good one.
but have you try to do M --> ODS?
maybe you can upgrade the M server to support more queries, this solution
simplify the overall process.
where do you want to use indexed views?
if it's on the MCOPY server, there is no advantage of these indexed views.
but using views as the source of your ETL process is a good option.
- Follow-Ups:
- References:
- Prev by Date: Re: Design choice in the Use of SQl Server Views for ETL
- Next by Date: Re: Design choice in the Use of SQl Server Views for ETL
- Previous by thread: Re: Design choice in the Use of SQl Server Views for ETL
- Next by thread: Re: Design choice in the Use of SQl Server Views for ETL
- Index(es):
Relevant Pages
|
Loading
