> Would this be a static filter or a dynamic filter, ie where store_id=2
> (static) or where store_id=hostname() (dynamic)?
>
> There is more processing involved in using filters. The impact may vary
> widely.
>
>

"Combfilter" <adsf@asdf.com> wrote in message
news:MPG.1c0e66c5405f97bc9896ef@news.newsreader.com...
> Hello.
>
> I need to setup a filter for a really busy db
> that we are replicating. I was wondering what
> type of filter to use. I am afraid that the
> where clause of a row filter will create a major
> performance hit. I was looking into dts and
> Transformable Subscriptions but am not real clear
> if that would be better.
>
> any advice would be appreciated.
>
> thanks,
>
> -comb

"Combfilter" <adsf@asdf.com> wrote in message
news:MPG.1c0e87f9669ff2889896f0@news.newsreader.com...
> In article <OmLTYxk0EHA.1932
> @TK2MSFTNGP09.phx.gbl>, hilary.cotter@gmail.com
> says...
>> Would this be a static filter or a dynamic filter, ie where store_id=2
>> (static) or where store_id=hostname() (dynamic)?
>>
>> There is more processing involved in using filters. The impact may vary
>> widely.
>>
>>
> it's static. where fkstoreid in (5001,5002)
>
> like that.
>
> -comb

> is fkstoreid indexed?
>
>