Posted by Anthony Paul on 04/18/07 13:07
I just finished looking up using indexed views versus a filter for
replication and it turns out that the view is much slower than a
filter (about 3x as slow) because the log reader has to log each
transaction twice, once for the view and once for the table. In my
case performance is of utmost concern so the overhead involved in this
is not something they can live with. Sigh...
> > Is it possible to create views, then configure things so that just
> > those views are replicated as tables on the second server?- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
[Back to original message]
|