VS2005 - Merge Rep Performance.

[Guest]

(Previously posted in the “microsoft.public.sqlserver.ce†newsgroup but got
no response.)

Ok, so I successfully converted my VS2003 CF application to VS2005 including
an update from SQL Server CE to SQL Server Mobile Edition and an update of
the merge replication (MR) agent from sqlcesa20.dll to sqlcesa30.dll. Both
the old application and it’s converted counterpart are hitting SQL server
2000 SP4 on the back end.

It appears to me that MR is slower on the VS2005 platform. The old app
would replicate in 8 sec. and the new app takes 13 seconds when hitting the
same servers. The SQL that produces the replicated tables is the same for
both replication setups and has been optimized.

I would like input from those who have implemented CF applications on the
VS2005 platform that use MR. Have you found it as robust as VS2003? How
have you found the performance? Is it faster if you hit SQL Server 2005 on
the back end, and slower if you are hitting SQL Server 2000? In hindsight
would you have made a different choice? Has MR improved or regressed with
the new version supported by VS2005?

Bill

 

[Guest]

C'mon guys, surely I'm not the only one who has implemented MR on the VS2005
platform with SQL Mobile Edition.. or am I?

 

[Lonifasiko]

I use MR with SQL Server 2005 backend and I'm quite happy with the
response time.
Don't know if it's slower with SQL Server 2000.

Bye.

 

[Brian Nantz]

I am working on MR on VS2005 and kind of am interested in your response.
I have not done it with 2003 so I have no reference to compare
performance.