joined dynamic filters VS dynamic filters [mergerepl] 
Author Message
 joined dynamic filters VS dynamic filters [mergerepl]


Joined dynamic filters seem to take forever to process on the server
compared to normal dynamic filters.... I notice it doesnt use bcp for init
snapshot, like non-filtered repl

theres only about 7 tables 300K rows each...
I indexed the filtered row on each one...

I have 5 laptops on the lan, doing the initial sync, doing all 5 at once
bogs down the server, + just one takes hours.... why is it so slow??

Non-joined dynamic filters at least finish with in the hour...

what else can I do to speed things up? diff indexes? etc...

server:    dual Piii500, 256MB ECC RAM

Scott Kramer

Mon, 13 Jan 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Dynamic filter vs static filter...

2. Merge Replication with Dynamic Filter and Row Filter failure on two Deletes

3. Dynamic Filter on TCustomADODataset where filter field data type change

4. Dynamic snapshot/dynamic filter

5. Dynamic filter with join dont work

6. MERGE REPL -- Changing Dynamic Join Filter

7. Dynamic Merge Filter Join Clause

8. FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE Subscribers

9. Row Filter & Join Filter

10. Problem with filters and join filters in merge replication

11. Join Filters not filtering

12. Merge replication with dynamic filters

Powered by phpBB® Forum Software